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

Of course you can do it! This should give you some ideas:
http://www.mvps.org/dmcritchie/excel/sheets.htm

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Inobugs" wrote:

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

I went through the sheet at the link
"http://www.mvps.org/dmcritchie/excel/sheets.htm" three times. While I use
Excel extensively, I do not have a sufficient understanding of the coding in
macros and Visual Basic to unsderstand which part of the reference page you
sent may help me solve my issue. If I could name cells so the names continued
to refer to the same cell data (formula or value) even after a sort, that
would work fine. Otherwise, might you be able to give me more explicit
information as to how to sort the source sheet while the linked refernces on
the destination sheet (in another workbook) refer to same cell data on the
source sheet; even though its position on the source sheet has changed?
Thanks.
Dan

"ryguy7272" wrote:

Of course you can do it! This should give you some ideas:
http://www.mvps.org/dmcritchie/excel/sheets.htm

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Inobugs" wrote:

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

On Apr 19, 9:33*pm, Inobugs wrote:
I went through the sheet at the link
"http://www.mvps.org/dmcritchie/excel/sheets.htm" three times. While I use
Excel extensively, I do not have a sufficient understanding of the coding in
macros and Visual Basic to unsderstand which part of the reference page you
sent may help me solve my issue. If I could name cells so the names continued
to refer to the same cell data (formula or value) even after a sort, that
would work fine. Otherwise, might you be able to give me more explicit
information as to how to sort the source sheet while the linked refernces on
the destination sheet (in another workbook) refer to same cell data on the
source sheet; even though its position on the source sheet has changed?
Thanks.
Dan

"ryguy7272" wrote:
Of course you can do it! *This should give you some ideas:
http://www.mvps.org/dmcritchie/excel/sheets.htm

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

"Inobugs" wrote:

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.