|
AutoFill with sheet reference help
OOPS on my part...
It works for Column A though which is the first part. I forgot about Column B :-/ A B sheet1!a1 sheet1!c1 sheet1!a1 sheet1!d1 sheet1!a1 sheet1!e1 sheet1!a2 sheet1!c2 sheet1!a2 sheet1!d2 sheet1!a2 sheet1!e2 Sorry about that.. and Thanks... "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 |
AutoFill with sheet reference help
For column B, entered in B1:
=INDEX(Sheet1!C:E,INT(ROWS(B$1:B3)/3),MOD(ROWS(B$1:B3),3)+1) Copy down as needed. -- Biff Microsoft Excel MVP "TimeCloud" wrote in message ... OOPS on my part... It works for Column A though which is the first part. I forgot about Column B :-/ A B sheet1!a1 sheet1!c1 sheet1!a1 sheet1!d1 sheet1!a1 sheet1!e1 sheet1!a2 sheet1!c2 sheet1!a2 sheet1!d2 sheet1!a2 sheet1!e2 Sorry about that.. and Thanks... "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 |
AutoFill with sheet reference help
Worked great.. Thank you very much,
"T. Valko" wrote: For column B, entered in B1: =INDEX(Sheet1!C:E,INT(ROWS(B$1:B3)/3),MOD(ROWS(B$1:B3),3)+1) Copy down as needed. -- Biff Microsoft Excel MVP "TimeCloud" wrote in message ... OOPS on my part... It works for Column A though which is the first part. I forgot about Column B :-/ A B sheet1!a1 sheet1!c1 sheet1!a1 sheet1!d1 sheet1!a1 sheet1!e1 sheet1!a2 sheet1!c2 sheet1!a2 sheet1!d2 sheet1!a2 sheet1!e2 Sorry about that.. and Thanks... "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 |
AutoFill with sheet reference help
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "TimeCloud" wrote in message ... Worked great.. Thank you very much, "T. Valko" wrote: For column B, entered in B1: =INDEX(Sheet1!C:E,INT(ROWS(B$1:B3)/3),MOD(ROWS(B$1:B3),3)+1) Copy down as needed. -- Biff Microsoft Excel MVP "TimeCloud" wrote in message ... OOPS on my part... It works for Column A though which is the first part. I forgot about Column B :-/ A B sheet1!a1 sheet1!c1 sheet1!a1 sheet1!d1 sheet1!a1 sheet1!e1 sheet1!a2 sheet1!c2 sheet1!a2 sheet1!d2 sheet1!a2 sheet1!e2 Sorry about that.. and Thanks... "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 |
| All times are GMT +1. The time now is 05:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com