If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Relative Reference to another sheet?
I have what I think is or should be a relatively straightforward question.
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! An Example: ReportSheet!: Contents of cell A1: =DataSheet!C14 Contents of cell A2 interpretation necessary: =referenced location in cell A1, e.g. DataSheet!C14 Add one column to this location, e.g. DataSheet!D14 indicate value at DataSheet!D14 Contents of cell B5 interpretation necessary: =referenced location in cell A1, e.g. DataSheet!C14 Add ten rows to this location, e.g. DataSheet!C24 indicate value at DataSheet!C24 Contents of cell F2 interpretation necessary: =referenced 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 And so on..... Your help is appreciated Thanks! -Gary 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. |
Thread Tools | |
Display Modes | |
|
|