Can anyone help me create a vba function to execute the following?
In Sheet1 I have 3 columns
B(price) which are populated with 3000 items and 3rd column
C(quantity) which is not populated
I want to add quantities to certain products which will be done by finding the product and enter the amount in the corresponding cell C.
Then in Sheet2 or even specified different workbook to have added only all the products and prices and quantity that have quantity introduced.
For example, I have Sheet1:
I want to have sheet2 or a specified sheet/workbook automatically populated with the products and their matching prices and quantity that have quantities on like this:
I have managed to create an excel function but the products list is changing weekly and every time I have to copy/paste the formula and adapt the source file and is a complete hassle.
The formula I have made is here: