Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pull data from different worksheets/tab into one Pivot Table
I have a worksheet with separate tabs for each day of the month.
The tab/worksheet for each day has several pieces of data (all in columns) that need to be Pivoted out to show the information per day. For example on July 1st: Column A - Storefront Column B - Product Column C - # of orders for each of the Products and Storefront defined in A&B. The info in these columns will change by day depending on the orders actually made by customers. The tabs (days) are not identical with the Storefront and Product (due to the macro the programmer put in to compile the data from a raw data sheet) I need to somehow create one Pivot table that will reference each tab (day) and pull back the following data: Storefront Product Date and number of orders for each Storefront/Product. The finished Pivot Table should have (in the case of July - 31 days listed in it) with the total orders listed by day for each storefront & product. Any ideas on how to accomplish this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I select data in several Worksheets for a Pivot Table? | Charts and Charting in Excel | |||
entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
can a pivot table pull from multiple worksheets? | Excel Worksheet Functions | |||
Pull Pivot Table Data | Excel Discussion (Misc queries) | |||
Pull pivot table data | Excel Discussion (Misc queries) |