Is there a way to link information from an Excel spreadsheet on a source
worksheet to a second (destination) worksheet, sort the source workbook, and
even though the positioning of the cell location changes in the source book;
the same data (values) are linked to the second workbook as before the sort?
Neither using names, nor removing the string ($) sign from the linked data
formula has worked. I suspect I could use a lookup formula, but I do not want
to sort on the lookup reference value (that appears to need to be in
ascending order).
If the answer is no, I suppose I could create another sheet with the
reference data sorted in ascending order so a lookup formula works. I would
like to just link, sort the source sheet when I want, and have the second
workbook somehow retain reference to the same value as before the sort.
What's the simplest way to accomplish this? Thanks. May God's fresh blessings
be about you!
Dan