| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AutoFill with sheet reference help | Excel Worksheet Functions | |||
| Autofill a Sheet Reference | Excel Worksheet Functions | |||
| Autofill based on a cell reference | Excel Worksheet Functions | |||
| reference autofill. | Excel Worksheet Functions | |||
| Autofill/Reference Confusion | Excel Worksheet Functions | |||
Linear Mode
