| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Linking between worksheets- then sorting data
I have a list in Worksheet 1, and I link some values to Worksheet 2 by using
='Worksheet1'B1 formula. When I sort the list in Worksheet 1, the value in the linked cell in Worksheet 2 changes as well. I want the value to stay the same in Worksheet 2, and the formula updates. Is this possible? |
|
#2
|
|||
|
|||
|
If you sort the data in the original list, the linked data will sort
too, and you can't change this behaviour. Perhaps you could store all the data on sheet 1, instead of separating onto two sheets. You can hide columns or rows when you want to print. sahamill wrote: I have a list in Worksheet 1, and I link some values to Worksheet 2 by using ='Worksheet1'B1 formula. When I sort the list in Worksheet 1, the value in the linked cell in Worksheet 2 changes as well. I want the value to stay the same in Worksheet 2, and the formula updates. Is this possible? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Linking sheets when sorting row and column data | Excel Worksheet Functions | |||
| data entry on multiple worksheets | Excel Discussion (Misc queries) | |||
| Linking Data between worksheets in a workbook | Excel Worksheet Functions | |||
Hybrid Mode
