Hey guys! I have a monthly usage report I run through excel. I create this by exporting 2 different reports from quickbooks. an inventory report and a sales report. I have to combine these reports to make the usage report. We have thousands of items so this gets very tedious.
I have attached a basic sample of what I am dealing with. I was wondering if there would be a way for cell d3 to autofill with the data from j3. It sounds super easy, however i need it to be based of the item name. For Example: If cell A3 displays the same item as any of the cells I3-I6, then display the corresponding value (J3-J6) into cell D3. The same would need to be done for Quarter2 when working with columns E,L, and M.
The biggest issue is when I pull an sales report (Columns I, J), if item b was not sold during that period of time, it will not appear on the report. This means that column A and I will never match. Quickbooks inventory reporting is not very good.... So I need excel to search column I to find the value displayed in column A and put the corresponding value (column J) into the corresponding quarter (column D).