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.

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.