Forum Discussion
Autofill not recognizing the intended pattern
I am trying to autofill a series of cells from another Sheet but cannot get the autofill to follow the intended pattern correctly. The information in the first cell comes from ='Sheet1'!A1 I wa...
emil33 Try entering the following formula in cell A1 (on the destination sheet), then drag down as needed:
=INDEX(Sheet1!A:A, ROW() * 10 - 9)
However, if the first cell where you want to start the series is NOT in row 1 of the destination sheet, you will need to modify the formula to account for the row number of the first cell. For example, if the first cell is C5, enter the following formula in cell C5, then drag down as needed:
=INDEX(Sheet1!A:A, (ROW() - ROW($C$5) + 1) * 10 - 9)
See attached sample workbook, if needed...