Summarize Multi Worksheet Data
 

I need a way to create a summary page that queries data across mutiple tabs.
Each tab contains specific user data. I want the summary page to list an
overview of each user. I've been doing this via a Pivot Table but is there a
way that doesn't require me to compile all the data together in one worksheet
to query?

Summarize Multi Worksheet Data
 

In my opionion you are doing it the right way by compiling all of the data in
one worksheet and then extracting the data out as a pivot table. In my
experience this is the mose effective way as it is easy to add more user data
by just exteneding the data range of the pivot table. Adding new users is
handled for you and you can easily modify or add output reports without
having to muck with your source data by adding more sheets and such. What is
the issue that you are having with trying to keep all of the data on one
worksheet?
--
HTH...

Jim Thomlinson


"Becky Katzman" wrote:

I need a way to create a summary page that queries data across mutiple tabs.
Each tab contains specific user data. I want the summary page to list an
overview of each user. I've been doing this via a Pivot Table but is there a
way that doesn't require me to compile all the data together in one worksheet
to query?

Summarize Multi Worksheet Data
 

I'm dealing with thousands of entries so it seems like more work to copy and
paste the contents of each tab into a "Master" worksheet. Also, the pivot
table doesn't allow the summarized data to be sorted.

"Jim Thomlinson" wrote:

In my opionion you are doing it the right way by compiling all of the data in
one worksheet and then extracting the data out as a pivot table. In my
experience this is the mose effective way as it is easy to add more user data
by just exteneding the data range of the pivot table. Adding new users is
handled for you and you can easily modify or add output reports without
having to muck with your source data by adding more sheets and such. What is
the issue that you are having with trying to keep all of the data on one
worksheet?
--
HTH...

Jim Thomlinson


"Becky Katzman" wrote:

I need a way to create a summary page that queries data across mutiple tabs.
Each tab contains specific user data. I want the summary page to list an
overview of each user. I've been doing this via a Pivot Table but is there a
way that doesn't require me to compile all the data together in one worksheet
to query?

Summarize Multi Worksheet Data
 

Perhaps this will help. Check out Ron's web site. He has some excelent VBA
scripts for copyting data to a summary sheet

http://www.rondebruin.nl/summary.htm

Also pivot tables can be sorted. Right click on the data member you would
like to sort by and click Field Setting - Advanced. You can then set up your
sorting criteria.
--
HTH...

Jim Thomlinson


"Becky Katzman" wrote:

I'm dealing with thousands of entries so it seems like more work to copy and
paste the contents of each tab into a "Master" worksheet. Also, the pivot
table doesn't allow the summarized data to be sorted.

"Jim Thomlinson" wrote:

In my opionion you are doing it the right way by compiling all of the data in
one worksheet and then extracting the data out as a pivot table. In my
experience this is the mose effective way as it is easy to add more user data
by just exteneding the data range of the pivot table. Adding new users is
handled for you and you can easily modify or add output reports without
having to muck with your source data by adding more sheets and such. What is
the issue that you are having with trying to keep all of the data on one
worksheet?
--
HTH...

Jim Thomlinson


"Becky Katzman" wrote:

I need a way to create a summary page that queries data across mutiple tabs.
Each tab contains specific user data. I want the summary page to list an
overview of each user. I've been doing this via a Pivot Table but is there a
way that doesn't require me to compile all the data together in one worksheet
to query?