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. |
#2
|
|||
|
|||
I don't think you can do anything more using the method you're using.
Any chance you can put a key value in sheet2 and then use =vlookup() to retrieve the values you want. Debra Dalgleish has some instructions for =vlookup() and =index(match()) at: http://www.contextures.com/xlFunctions02.html and http://www.contextures.com/xlFunctions03.html Amie wrote: 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. -- Dave Peterson |
#3
|
|||
|
|||
I don't think that Vlookup will work, the table on the input page is not in
the same format as the chart page. Absolute values won't work either, I need to be able to change both the amount in each cell on the input page as well as be able to sort the input page in various ways. The chart page needs to reference the original input cell no matter where it ends up as the sorts happen. "Dave Peterson" wrote: I don't think you can do anything more using the method you're using. Any chance you can put a key value in sheet2 and then use =vlookup() to retrieve the values you want. Debra Dalgleish has some instructions for =vlookup() and =index(match()) at: http://www.contextures.com/xlFunctions02.html and http://www.contextures.com/xlFunctions03.html Amie wrote: 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. -- Dave Peterson |
Reply |
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 |