ExcelBanter - Copy/Fill Down in increments

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Copy/Fill Down in increments (https://www.excelbanter.com/excel-worksheet-functions/240113-copy-fill-down-increments.html)

Helen B[_2_]

Copy/Fill Down in increments

I have a fomula on sheet1 that refers to sheet2 and I want to copy/fill down
adding 51 each time.

Example in Sheet1 cell B4 is =Sheet2!E5, I want the result in B5 to be 51
rows later ie =Sheet2!E56

How can I autfill or copy down to automatically add 51.

Thanks

Jacob Skaria

Copy/Fill Down in increments

In Sheet1 cell B4 try the below formula and copy down

=INDIRECT("Sheet2!E"&(ROW(A1)-1)*51+5)

If this post helps click Yes
---------------
Jacob Skaria

"Helen B" wrote:

I have a fomula on sheet1 that refers to sheet2 and I want to copy/fill down
adding 51 each time.

Example in Sheet1 cell B4 is =Sheet2!E5, I want the result in B5 to be 51
rows later ie =Sheet2!E56

How can I autfill or copy down to automatically add 51.

Thanks

All times are GMT +1. The time now is 03:46 AM.