Forum Discussion
Consolidating tabs to a summary worksheet
I am trying to consolidate data from multiple tabs to a summary worksheet. It is a caseload report that is broken out by case manager on each tab. The headings are the same on each tab. I would lik...
I'm going to provide 2 workbooks which underscore this idea. Which is easiest to analyze?
The many sheets workbook... then I want all of the tabs to pull into a master tab that has all data. I should mention that I am working on a Mac.
The many sheets workbook... then I want all of the tabs to pull into a master tab that has all data
Don't be too hasty with that reply. I actually think Patrick2788 was asking not "Which arrangement of the raw data is clearer?" but rather "Which arrangement would you rather work with to produce your summary analysis?"
Yes, the raw data is "clearer" when you use separate sheets. That was my point to begin with. But the consolidated raw data is easier to work with. And it's working with that you're trying to do.
