Hi all,
I am looking to streamline the way I add and remove stock from a data base.
I have on one sheet a search function that finds a group of products and allows me to make a new temporary list of them in Column P starting in Row 9 and also to manually input a quantity which appears in the same row in Column U
I was wondering if there is a way to have 2 macros to add and remove stock, i.e make the list on the first sheet, click the add stock button and it would take the descriptions in Col P and use them to find the correct rows on the 'Products!' sheet in Row C3:C100 and add the relevant quantities to the figures already in stock in Row D3:D100.
With the remove stock button doing the opposite.
Thanks in advance.
Bookmarks