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

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