HELP - Referencing cells from different sheets using fixed increment

**Richard Buttrey** · 03-01-2014, 08:55 PM

Hi,

Something like this copied down.

Formula:

=OFFSET('Export Invoices'!C35,ROW()*40-40,0)

You'll need to adjust the ROW() reference as necessary. This assumes the formula starts in C1. Were ut to start in say C3 you'd need to 'rebalance' it with a -2 correction. i.e.

Formula:

=OFFSET('Export Invoices'!C35,(ROW()-2)*40-40,0)

**faisy110** · 03-01-2014, 11:01 PM

Hey, Thanks for the quick reply!
I tried it and it doesn't seem to work properly.. for some reason it jumped ahead 500 rows when i dragged it down..
Am I missing something?

Thanks a bunch

Edit: Also, I am not mirroring formulas, simply alphanumeric values.