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

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

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

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