Forum Discussion
Sorting tables that are in different sheets
mathetes Thank you for your answer!
The truth is that it's not possible for me to have fewer sheets. Let me explain why:
Basically, im working at radio company. Every sheet, represents the "position" of every radio station among every age group, depending on the percentage of their audience every hour.
I can't put them all together because you can understand that for example my radio station might be 2nd during 14:00-15:00 in the age group of 17-20, but in the 7th place during the same time in the age group of 25-30.
So my question remains the same. Can i sort at the same time different tables in different sheets?
You wrote:
The truth is that it's not possible for me to have fewer sheets. Let me explain why:
Basically, im working at radio company. Every sheet, represents the "position" of every radio station among every age group, depending on the percentage of their audience every hour.
I can't put them all together because you can understand that for example my radio station might be 2nd during 14:00-15:00 in the age group of 17-20, but in the 7th place during the same time in the age group of 25-30.
So my question remains the same. Can i sort at the same time different tables in different sheets?
And my response remains the same too. If you were to add the necessary qualifiers to each row in what are now separate tables, you could combine them all into a single database and still do the kind of sorting and querying that you're describing. I've been the director of a major database of a major corporation...we had to sort populations from different divisions, different locations, etc., and did it all from a single database. The very fact that you're looking for help in the way you're looking for it, for that purpose, underscores the fact that the way you've organized it is INTERFERING with letting Excel do what it can do very well.
But have it your way.