| 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? |
| 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 | |||
Threaded Mode
