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

[Ignobilitor]

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]

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

 

[Ignobilitor]

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