Thread: I need to make a sum function always equal the corresponding cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tarabull tarabull is offline
external usenet poster
  
Posts: 21
Default I need to make a sum function always equal the corresponding cell
in cell a1 of sheet 1, i have an addition formula that contains
"=+AU1+BB1+'sheet2'!a1" if i insert a line above a1 on sheet 1 and it becomes
a2, the formula automatically changes to "=+AU2+BB2+'sheet2'!a1", how can I
get it to automatically change to "=+AU2+BB2+'sheet2'!a2"?
Reply With QuoteReply With Quote