Home |
Search |
Today's Posts |
#1
|
|||
|
|||
AutoFill with Non-sequential Cell References ?
In one sheet I need to reference cells in a different sheet in the
same workbook. It's a long sheet of projections, so it would save me lots of time if I could use AutoFill to add references to the cells on the other sheet. The cells I want to reference are in the same row, but they're not in adjacent columns- specifically, they're located in every 5th. column (i.e. A2, E2, I2, etc.) If I start with a reference to A2 and use AutoFill, I get B2, C2, D2, etc. Is there any way to specify the realtivity of AutoFill to use every xth. row or xth. column? |
#2
|
|||
|
|||
Autofill generally likes 3 entries from which to "copy". So if you want
every fifth, do the first 3 entries manually, and then drag them with the autofill. Hope it helps! ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com wrote in message ... In one sheet I need to reference cells in a different sheet in the same workbook. It's a long sheet of projections, so it would save me lots of time if I could use AutoFill to add references to the cells on the other sheet. The cells I want to reference are in the same row, but they're not in adjacent columns- specifically, they're located in every 5th. column (i.e. A2, E2, I2, etc.) If I start with a reference to A2 and use AutoFill, I get B2, C2, D2, etc. Is there any way to specify the realtivity of AutoFill to use every xth. row or xth. column? |
#3
|
|||
|
|||
Anne Troy- I just tried and couldn't get that to work.
I'm trying to fill in a column on one work sheet- cells D4, D5, D6, etc. with references to cells in a different worksheet on the same row on every 4th. column- C40, G40, K40, etc. thanks. "Anne Troy" wrote: Autofill generally likes 3 entries from which to "copy". So if you want every fifth, do the first 3 entries manually, and then drag them with the autofill. Hope it helps! ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com wrote in message ... In one sheet I need to reference cells in a different sheet in the same workbook. It's a long sheet of projections, so it would save me lots of time if I could use AutoFill to add references to the cells on the other sheet. The cells I want to reference are in the same row, but they're not in adjacent columns- specifically, they're located in every 5th. column (i.e. A2, E2, I2, etc.) If I start with a reference to A2 and use AutoFill, I get B2, C2, D2, etc. Is there any way to specify the realtivity of AutoFill to use every xth. row or xth. column? |
#4
|
|||
|
|||
Hi!
If what you're try to do is this: =A2.....=E2......=I2 Or =A2 =A6 =A10 To reference horizontally across the row: =OFFSET($A2,,(COLUMN(A:A)-1)*4) To reference vertically down the column: =OFFSET(A$2,(ROW(1:1)-1)*4,,) Biff wrote in message ... In one sheet I need to reference cells in a different sheet in the same workbook. It's a long sheet of projections, so it would save me lots of time if I could use AutoFill to add references to the cells on the other sheet. The cells I want to reference are in the same row, but they're not in adjacent columns- specifically, they're located in every 5th. column (i.e. A2, E2, I2, etc.) If I start with a reference to A2 and use AutoFill, I get B2, C2, D2, etc. Is there any way to specify the realtivity of AutoFill to use every xth. row or xth. column? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Cell References and External Data | Excel Worksheet Functions | |||
Copying linked cell references. | Excel Worksheet Functions | |||
Cell References in Functiona | Excel Worksheet Functions | |||
Excel: how to formulate conditional cell references | Excel Worksheet Functions |