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? |
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 |