sort source data sheet while destination shows same data

I

Inobugs

Is there a way to link information from an Excel spreadsheet in a source
workbook to a second (destination) workbook, 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
has worked. I suspect I could use a lookup formula, but I do not want
to sort source 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting Linked Data Between Sheets 3
Retaining cell reference in destination, when sorting source file 3
sort source workbook data, maintain formulas in destination workb. 2
copied formulas refer to destination sheet not source sheet 2
How can I insert a row in a source that links to a destination 1
linking workbooks when source data moves 1
Excel-how to link source workbook to copy of destination workbook 1
Referencing another workbook using a variable for the sheet? 20

Top