I'm new to excel and just received a task to simplify/reorganize 5 sheets of data into one final sheet. This final sheet will then a reference to a inventory/sales report that will be made on another sheet...
I've been thinking of ways to make this work, and here are my brainstorming conclusions...
1) Use VLOOKUP ON A FILTERED DATA... except, I don't know how to do this...Is there a formula to this method?
2) Use Pivot table and then reference it to the inventory/sales report at the end... (but I don't know if it will reference data from a pivot table to the final report - does it?)
3) If I were to use a pivot table, the data that is selected from the worksheet isn't cooperating... For example, the months on the top are no where to be found on the pivot table, so the data below each month (on order and on po - which only includes numbers) become my columns. Is there any way I can group the two data below each month together in the pivot table under a newly made month column?
If anybody can help me resolve this issue, it'll be greatly appreciated - you're saving my life! Thank you!
I've been thinking of ways to make this work, and here are my brainstorming conclusions...
1) Use VLOOKUP ON A FILTERED DATA... except, I don't know how to do this...Is there a formula to this method?
2) Use Pivot table and then reference it to the inventory/sales report at the end... (but I don't know if it will reference data from a pivot table to the final report - does it?)
3) If I were to use a pivot table, the data that is selected from the worksheet isn't cooperating... For example, the months on the top are no where to be found on the pivot table, so the data below each month (on order and on po - which only includes numbers) become my columns. Is there any way I can group the two data below each month together in the pivot table under a newly made month column?
If anybody can help me resolve this issue, it'll be greatly appreciated - you're saving my life! Thank you!
