ExcelBanter - AutoFill with sheet reference help

Tell me where to send the beer... Thanks a ton!!!

"T. Valko" wrote:

Assume you enter the first formula on some sheet in cell A1:

=INDEX(Sheet1!A:A,CEILING(ROWS(A$1:A1)/3,1))

Copy down as needed.

--
Biff
Microsoft Excel MVP

"TimeCloud" wrote in message
...
I am trying to use autofill to copy a sheet reference as follows:

=sheet1!a1
=sheet1!a1
=sheet1!a1
=sheet1!a2
=sheet1!a2
=sheet1!a2
=sheet1!a3
=sheet1!a3
=sheet1!a3

The autofill can't figure out my pattern and will not fill in the formula
properly it skips numbers.

TIA