Thread: auto fill every other cell from other workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
fullodds fullodds is offline
external usenet poster
  
Posts: 2
Default 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




Reply With QuoteReply With Quote