Incrementing rows (or columns) to a reference in another worksheet
 

Hi,

Here's my situation:

I have a workbook in which I'd like to reference a cell in another
worksheet, but would like to increment the reference as I move down rows
in the original worksheet.

For example, on Worksheet 1, cell A1 contains "=Worksheet2!A192". In
cell A2, I would like to reference "=A1 + [whatever I'd put in here that
would result in the reference actually being "=Worksheet2!A196"]"

The whole point is to be able to copy the cell down without having to go
in and enter the exact references manually.

Hope this makes sense...

Thanks!

Stefan

In cell A2, the formula would be:
=A1 + OFFSET(Worksheet2!$A$192, (ROW() - 1) * 4, 0)


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Ignobilitor" wrote in message
...
Hi,

Here's my situation:

I have a workbook in which I'd like to reference a cell in another
worksheet, but would like to increment the reference as I move down rows
in the original worksheet.

For example, on Worksheet 1, cell A1 contains "=Worksheet2!A192". In cell
A2, I would like to reference "=A1 + [whatever I'd put in here that would
result in the reference actually being "=Worksheet2!A196"]"

The whole point is to be able to copy the cell down without having to go
in and enter the exact references manually.

Hope this makes sense...

Thanks!

Stefan

Rob van Gelder wrote:
In cell A2, the formula would be:
=A1 + OFFSET(Worksheet2!$A$192, (ROW() - 1) * 4, 0)


Thank you, Rob! I'll give this a try.

Stefan