Increment cell reference by six rows

[rwebber]

I have the following formula in two rows of a spreadsheet:

=('PASTE-rpt'!B5937)
=('PASTE-rpt'!B5943)

I want to extend this pattern for several more rows, but can't get autofill to maintain the every sixth row increment. Here is what happens:

=('PASTE-rpt'!B5937)
=('PASTE-rpt'!B5943)
=('PASTE-rpt'!B5939)
=('PASTE-rpt'!B5945)

The increment of row 3 is a value of 2 instead of 6.

Seems like a simple issue and I hesitate to post, but I could use the help.

 

[ravishankar]

HI
Assuming your data starts from row 1 try,
=indirect("'PASTE-rpt'!B" & 5931 + row()*6)
Ravi