Hello.
I am currently working with a spreadsheet with sales in stores across multiple states, with the same dates as columns and same calculations/names for rows. Essentially, there are about 15 different tabs with the same general layout but different unique data. What I want to do is consolidate this data into one tab, where I can simply click on a filter to examine the data for different states, instead of navigating back and forth between tabs. I don't want summarize the data, I want to leave it how it is, I just want a simpler, more effective way of looking through this data.
Thanks a ton for your help.
I am currently working with a spreadsheet with sales in stores across multiple states, with the same dates as columns and same calculations/names for rows. Essentially, there are about 15 different tabs with the same general layout but different unique data. What I want to do is consolidate this data into one tab, where I can simply click on a filter to examine the data for different states, instead of navigating back and forth between tabs. I don't want summarize the data, I want to leave it how it is, I just want a simpler, more effective way of looking through this data.
Thanks a ton for your help.
