Copy/Paste with Fixed Increment to Cell Reference

[niranjanbt]

Hi,

Let's assume some data in A1 through A10. A1 through A5 contains one group of data and A6 through A10 another.
I have referenced A1 in B1. When I copy/paste B1 to B2, I would like the cell reference to increment by 5 (to refer A6) instead of just 1. What would be the easiest way to achieve this?

Thanks,
Niranjan

 

[Joe4]

Try:

=INDIRECT("A" & (ROW()*5-4))