HELP - Referencing cells from different sheets using fixed increment

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)