Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to update data from multiple sheets to one specific sheets | Excel Discussion (Misc queries) | |||
sorting multiple sheets with one button? | Excel Discussion (Misc queries) | |||
help sorting multiple sheets | Excel Discussion (Misc queries) | |||
sorting sheets | New Users to Excel | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions |