View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default "='sheet 1'!D4" auto fill sheet to sheet ='sheet 2'!D4

You can use the INDIRECT function to do this. Note that this will work only
with sheets that have a name of SheetN, where N is some number. It will
*not* work if the sheet have other names.

Enter the following formula in some cell, and change the value N in the
formula to the row number in which it was first entered.

=INDIRECT("'Sheet"&ROW()-N+1&"'!D4")

Now, fill down for as many cells as you have sheets.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"mistewalker" wrote in message
...
how do auto fill formula ='sheet 1'!D4 to sheet 2 ='sheet 2'!D4
with out change the formula maunually
I want to make one sheet with the formula and add sheets and have the new
sheet look at the adjacent sheet etc