Relative Reference to another sheet?
See also a reply in your earlier thread today.
Regards
Anders Silven
"Gary" skrev i meddelandet =
news:uEl6c.37416$Zp.9518@fed1read07...
I have what I think is or should be a relatively straightforward =
question.
=20
I have a data sheet that is designed for a very small screen, i.e. an =
IPAQ.
From the various and voluminous amounts of data on this sheet I would =
like
to pull a "Report" in a new sheet, hence the "Report Sheet". I would =
like to
format the new sheet such that all I have to do in input a "Single
Reference" in a single cell on the "Report Sheet". This "Single =
Reference"
would point to the data sheet. The "Report Sheet", by way of some kind =
of
relative referencing to the "Single Reference", would then =
spontaneously
populate the entire report. My data sheet is organized such that I can
always use relative references to my "Single Reference". I hope I have
iterated this well enough so that someone will be able to assist me. =
Thanks!
=20
An Example:
=20
ReportSheet!:
=20
Contents of cell A1:
=3DDataSheet!C14
=20
Contents of cell A2 interpretation necessary:
=3Dreferenced location in cell A1, e.g. DataSheet!C14 Add one =
column to
this
location, e.g. DataSheet!D14 indicate value at DataSheet!D14
=20
Contents of cell B5 interpretation necessary:
=3Dreferenced location in cell A1, e.g. DataSheet!C14 Add ten rows =
to this
location,
e.g. DataSheet!C24 indicate value at DataSheet!C24
=20
Contents of cell F2 interpretation necessary:
=3Dreferenced location in cell A1, e.g. DataSheet!C14 Subtract two =
rows and
add one
column to this location, e.g. DataSheet!D12 indicate value at
DataSheet!D12
=20
And so on.....
=20
=20
Your help is appreciated Thanks!
=20
-Gary
=20
P.S. I have played for hours with the following functions, to no =
avail:
INDIRECT, OFFSET, ADDRESS, CELL, and T. I believe that one or more of =
these
are involved in the solution, but cannot discern which.
=20
|