Cross Referencing between worksheets

[David Brereton]

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.

 

[Kevin B]

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