I am looking to add a delete list button but struggling to figure out how.
I added a ‘add to shopping list button’ but had to do some workaround work in my sheets (image attached) so now i think i have made to difficult to create a delete list button.
I am happy for any tips or recommendations on what i can do. I am not married to the ‘shopping list’ set up so happy to change it
The above image shows that when i click the add to shopping list button it adds a cell to this sheet and then i sue the transpose formula to separate the data in the cell.
This image is a pivot table i ave created from column B in the data from the above image.
I am happy to answer any questions or pay for time if needed