Pivot Table Range 1

[Ray1127]

I have an Excel 2010 worksheet with 3 Detail Worksheets 1 for Urgent care, 1 for Emergency Room and 1 for Inpatients.

I have 4 Summary Worksheets each with a Pivot Table Summarizing the data by Month. Again 1 for Urgent Care 1 for Er and 1 for Inpatients. All work well. The 4th is giving me a problem and I'm not sure how to fix it. The 4th will also be a Pivot Table combining the ER and Urgent care data with a graph to compare the 2 on 1 worksheet. Can you specify the source of 1 Pivot table to 2 different worksheets. I've been trying to do that all afternoon and gotten nowhere. Any help will be appreciated.

 

[SkipVought]

hi,

I have an Excel 2010 worksheet with 3 Detail Worksheets...

As I read your opening statement, I instinctively thought, "that's where the problem is!"

If there is any way to logically combine this data, assuming that the column headings are identical, then that is the way to go. You must add a column to identify the rows from each sheet. Then a simple PT can summarize.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Ray1127]

Thanks skip. Since the data was already there in the 2 detail spreadsheets I was trying to use what was there. By combining the 2 it was simple. I guess that's why they include the Stupid when they say keep it simple. Too many people (especially me) try to complicate the hell out of it. Thanks again.