Thread: How do I copy a formula with increasing worksheet numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Harrison_05
 
Posts: n/a
Default How do I copy a formula with increasing worksheet numbers
My worksheets are numbered 1 - 25.

my formula is: =IF(B$3='1'!$E$6,1,0). I want to copy this formalu into the
next column and have the worksheet name automatically change from 1 to 2.
Is this possible?
Reply With QuoteReply With Quote