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.
Bookmarks