View Single Post
  #2  
Old April 18th, 2009, 09:36 PM posted to microsoft.public.excel.worksheet.functions
ryguy7272
external usenet poster
 
Posts: 1,593
Default sort source data sheet while destination shows same data

Give this a look:
http://www.cpearson.com/excel/indirect.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 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