How to pick data from cells?
Good day learned folks of the microsoft forum, I have attached a spreadsheet that contains 4 tabs. I have most of it figured out except I want to create some data on the sales report tab but I need to have excel search the product list to determine how many units of each product were sold, and then populate that number into the qty sold (column B) field of my sales report tab. I know I can do this manually but I was hoping there's some way to have the excel do this for me. Any ideas? Many thanks
|