auto fill every other cell from other workbook

G

Guest

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
 
T

T. Valko

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
 
G

Guest

Outstanding!

Thank you

T. Valko said:
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 said:
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
Click to expand...
Click to expand...
 
T

T. Valko

You're welcome. Thanks for the feedback!

Biff

fullodds said:
Outstanding!

Thank you

T. Valko said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COpy formulas from one workbook to another workbook 2
Copying data from one workbook to another dependent on user select 1
Vlookup on multiple workbooks 12
Auto Fill Cell Based on Data in a different cell 4
Update Cell in WKBook 1 From WkBook 2 2
How do I reference the same cell in all previous sheets? 3
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Auto Fill, Every other column 5

Top