Related Posts
Why are weddings so expensive?!
Additional Posts in Excel Genius
Best pdf to excel converter?
Google Sheets vs Excel - pros? cons? differences?
What's the F4 analogy in Office 365?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
The best I've found is four pivot tables filtered for location in each of the tabs. Would love to hear other ways
I agree. I think this is honestly the most efficient method.
If not pivot, look into doing each sheet as a query of the master table sheet which would just pull each specific location
How much data?
It's not a lot. Currently only 300 rows but I will keep adding to it
I would like to do it without a pivot, basically want sheets 2-4 to have all the same data and formatting but only filtered by location. So sheet 2 will have all data from location a, sheet 3 from location b etc
Do you have or in the future is it possible for you to have “duplicate” data within each location?
Good approach
OMG I have this same question