Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract data from multiple sheets
Hi,
I have 5 worksheets that contain lists of products and their sales. I have a column that allows a user to mark if they want to 'drop' and item or 'add' an item. I have another worksheet that is supposed to summarize all of 'drops' and 'adds'. The data is set up like this: Product, Sales, Sales/MM, ACV, Drop Product, Sales, Sales/MM, ACV, Add I am more looking for a methodology that I can adapt to my dataset so do not worry about exactness. Thanks in advance for any help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
Extract information from Multiple sheets | Excel Discussion (Misc queries) | |||
extract data from multiple worksheets | Excel Worksheet Functions | |||
Extract Data from Multiple worksheets | Excel Programming | |||
How to extract data from multiple worksheets.. | Excel Discussion (Misc queries) |