Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summary sheet in effecient way
All
I have xls files each months of the year in a folder. I have made pivot tables in each of the workbooks which is something like this Clients SalesGroup Quantity a group1 25 group2 10 a subtotal 35 b group2 10 b subtotal 10 c group1 5 group2 10 c subtotal 15 In this pivot table i have grouped the sales representatives for each region. Now I want to make a summary sheet for all the months. This can look something like this: Clients jan feb mar apr.................. a 35 west region 10 east region 25 b 10 west region 10 In the particular format i have group2 to be named as west region and group1 as east region. The first row of Jan shows the total Quantity for Client a. The pivot tables have the clients in the sorted ascending order. The summary sheet should have the clients in sorted order and each having three rows showing total,west region total ( group2), east region total (group1). The clients in summary sheet can be added in the client column in sorted order and correponding values as per the pivot in the xls files. I have grouped the sales represntives in the reverse order in my monthly xls files wheres in my summary sheet i would like them to appear as west region for group2 and then east region for group1. I would like an efficient way of doing this as my excel does not support pasting in autofiltered coloumns. Thankue in advance for any suggestions. Regards Sumit |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic udates on a summary sheet | Excel Discussion (Misc queries) | |||
Displaying information (contained in defined names) on a summary sheet, in different row numbers? | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Linking References from Multiple Sheets to One Summary Sheet | Setting up and Configuration of Excel | |||
How do I reference values from 200 worksheets onto a summary sheet | Excel Discussion (Misc queries) |