Cross Referencing between worksheets
If you look at your cross reference formula the cell address in the look
something like this:
$A$1
Just remove the $ from the cell reference to make the cell relative and then
copy it down a column or across a row.
The $ indicates an absolute reference that does not change when copied.
Cells can be addressed in the following manner:
A1 = Relative cell where both column and row adjust when copied
A$1 = Relative column, absolute row
$A1 = Absolute column, relative row
$A$1 = Absolute column, absolute row
--
Kevin Backmann
"David Brereton" wrote:
OK. Help please.
worksheet one contains hundreds of rows of information. Worksheets 2-5 have
many formula cross references to this first worksheet to pull information
from a selected row. How do I identity to the other worksheets which row to
take the information from.
IE A formula on worksheet two might be "='Letter Info'!L1" ... however I
need to vary the line from L1 to maybe L2 or L3 or L4. Apart from changing
manually as this occurs for many columns , how do I make reference to which
row to take the information from ??
Any help greatly appreciated.
|