Sorting Multiple Sheets
 

I have a workbook with 5 sheets in it. Each sheet has the same name in the
first column however all other columns in each sheet are different.

There are around 300+ rows in each sheet. I would like to be able to sort
the first sheet and it in turn sorts all other sheets the same way. That way
if someone is looking at row 56 on the first sheet row 56 would be the same
for all other sheets.

In a perfect world if I sorted any of the sheets it orders all other sheets
in the same way. Basically if I were to put all the sheets into one huge
sheet and be able to sort anyway I want. The issue is spreading that across
multiple sheets.

Hope I explained that well enough

Thanks,
Fred

Sorting Multiple Sheets
 

If your sorting on the first column in each sheet individually and the first
column of each sheet all have the same list of names in the first column as
there are in the first sheet, then the rows should match. Just sort each
sheet individually on the first column.

--
Regards,
Tom Ogilvy

"FHKBaker" wrote in message
...
I have a workbook with 5 sheets in it. Each sheet has the same name in the
first column however all other columns in each sheet are different.

There are around 300+ rows in each sheet. I would like to be able to sort
the first sheet and it in turn sorts all other sheets the same way. That
way
if someone is looking at row 56 on the first sheet row 56 would be the
same
for all other sheets.

In a perfect world if I sorted any of the sheets it orders all other
sheets
in the same way. Basically if I were to put all the sheets into one huge
sheet and be able to sort anyway I want. The issue is spreading that
across
multiple sheets.

Hope I explained that well enough

Thanks,
Fred

Sorting Multiple Sheets
 

Here is the ugly way I came about doing it.

Created a master sheet and put all data next to each other. Then went to
each sheet and referenced the cells in the master sheet directly. Then on the
main sheet I hid all the columns except for the first sheet fields.

Now if I sort the first page it sorts all pages but shows up on the other
pages as direct references. It's cludgy I'm sure but works.

"Tom Ogilvy" wrote:

If your sorting on the first column in each sheet individually and the first
column of each sheet all have the same list of names in the first column as
there are in the first sheet, then the rows should match. Just sort each
sheet individually on the first column.

--
Regards,
Tom Ogilvy

"FHKBaker" wrote in message
...
I have a workbook with 5 sheets in it. Each sheet has the same name in the
first column however all other columns in each sheet are different.

There are around 300+ rows in each sheet. I would like to be able to sort
the first sheet and it in turn sorts all other sheets the same way. That
way
if someone is looking at row 56 on the first sheet row 56 would be the
same
for all other sheets.

In a perfect world if I sorted any of the sheets it orders all other
sheets
in the same way. Basically if I were to put all the sheets into one huge
sheet and be able to sort anyway I want. The issue is spreading that
across
multiple sheets.

Hope I explained that well enough

Thanks,
Fred