Hi everyone!
I'm fairly new to macros and VBA - so please excuse any stupid questions - but I'm hoping you can help me out.
I'm trying to create a macro which will add selected items to a shopping list. When I click the "+" icon next to the item I want that item to be added to the shopping list on a different sheet, on the line below whatever has previously been added.
On the attached document please see the first and second sheets which demonstrate what I'm trying to do.
If what I am asking for is an easy task for you, and you wantsomething a little more challenging to get stuck into I have also added sheets 3 and 4, which show how I would have the sheet running in a perfect world. The add symbol would open up a pop-up which would allow me to enter in the quantity and units required. Pressing the "Add" button would transfer all of this data into the shopping list.
I don't know if this is something which is possible, and I would be very happy if it only worked as I suggested in the more simple format, but if you could manage to create the pop-up that would be amazing.
Thank you for your time, it is greatly appreciated and I hope you are able to help.
Many thanks!
Bookmarks