| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I data sort multiple sheets in Excel that are linked with i
I am working with one document that has four worksheets. Each worksheet
shows different pieces of information about a client. However, to save time, I have "pulled through" the names from the first worksheet (using the = command in subsequent worksheets and clicking in the box from the first page). Nevertheless, when I data sort the first page to alphabetize it, on the other three worksheets, the information entered on the line with each name does not travel with the name as it is alphabetized. Is it possible to data sort with multiple sheets and have the information entered on a line with each name travel with it? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I data sort multiple sheets in Excel that are linked with i
It sounds like your best bet is probably to copy pastespecial values the
formulas that refer to the sheet that is going to be sorted. "yojlem" wrote: I am working with one document that has four worksheets. Each worksheet shows different pieces of information about a client. However, to save time, I have "pulled through" the names from the first worksheet (using the = command in subsequent worksheets and clicking in the box from the first page). Nevertheless, when I data sort the first page to alphabetize it, on the other three worksheets, the information entered on the line with each name does not travel with the name as it is alphabetized. Is it possible to data sort with multiple sheets and have the information entered on a line with each name travel with it? |
|
#3
|
|||
|
|||
|
Dear yojlem,
Did you arrive to solve this problem? I am facing a similar problem. If yes, can you please let me know how you solved it. Best, Jennifer |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort data on multiple worksheets | Excel Discussion (Misc queries) | |||
| Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
| New Excel data does not appear in linked Access table | Excel Discussion (Misc queries) | |||
| Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
| multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
Linear Mode
