| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto fill every other cell from other workbook
In a 3-D refence, how do I use auto fill to quickly reference every other
cell from workbook1 to workbook2. I want to autofill this: ='[GR Receipts Test 2.xls]Mill'!$E$6 to look like this: ='[GR Receipts.xls]Mill'!$E$6 ='[GR Receipts.xls]Mill'!$E$8 ='[GR Receipts.xls]Mill'!$E$10 Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto fill every other cell from other workbook
Try this:
=INDEX('[GR Receipts.xls]Mill'!$E$6:$E$100,ROWS($1:1)*2-1) Copy down as needed. Adjust for the correct end of the range! Biff "fullodds" wrote in message ... In a 3-D refence, how do I use auto fill to quickly reference every other cell from workbook1 to workbook2. I want to autofill this: ='[GR Receipts Test 2.xls]Mill'!$E$6 to look like this: ='[GR Receipts.xls]Mill'!$E$6 ='[GR Receipts.xls]Mill'!$E$8 ='[GR Receipts.xls]Mill'!$E$10 Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto fill every other cell from other workbook
Outstanding!
Thank you "T. Valko" wrote: Try this: =INDEX('[GR Receipts.xls]Mill'!$E$6:$E$100,ROWS($1:1)*2-1) Copy down as needed. Adjust for the correct end of the range! Biff "fullodds" wrote in message ... In a 3-D refence, how do I use auto fill to quickly reference every other cell from workbook1 to workbook2. I want to autofill this: ='[GR Receipts Test 2.xls]Mill'!$E$6 to look like this: ='[GR Receipts.xls]Mill'!$E$6 ='[GR Receipts.xls]Mill'!$E$8 ='[GR Receipts.xls]Mill'!$E$10 Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto fill every other cell from other workbook
You're welcome. Thanks for the feedback!
Biff "fullodds" wrote in message ... Outstanding! Thank you "T. Valko" wrote: Try this: =INDEX('[GR Receipts.xls]Mill'!$E$6:$E$100,ROWS($1:1)*2-1) Copy down as needed. Adjust for the correct end of the range! Biff "fullodds" wrote in message ... In a 3-D refence, how do I use auto fill to quickly reference every other cell from workbook1 to workbook2. I want to autofill this: ='[GR Receipts Test 2.xls]Mill'!$E$6 to look like this: ='[GR Receipts.xls]Mill'!$E$6 ='[GR Receipts.xls]Mill'!$E$8 ='[GR Receipts.xls]Mill'!$E$10 Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New numbers | Excel Worksheet Functions | |||
| Data referencing and auto fill across worksheets in one workbook.. | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
Linear Mode
