| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
linking values from one sheet to another
I have a workbook with 2 sheets. The input sheet has dollar values for 300
objects. I link the cells from the input sheet to the chart sheet by entering "+" in the cell on the chart sheet then going to get the amount on the input sheet. However, when I do a data sort on the input sheet, the values on the chart sheet change. I need the values on the chart sheet to stay "follow" the cell on the input sheet when I do data sorts on the input sheet. Hope I've explained it ok. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking to an Entire Sheet | Links and Linking in Excel | |||
| Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
| Values in 'Balance sheet' template are in $ I want £ but there is. | Excel Discussion (Misc queries) | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Threaded Mode
