Thread: Changing multiple formulas at one time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
poorsister
 
Posts: n/a
Default Changing multiple formulas at one time
I have a workbook with 30 worksheets that all have approximately 100 formulas
that read =(Cell)*.0342. I want to change the formula to read
=(Cell)*($AA$1) so I can change the value to $AA$1 as inflation changes. Is
there a way to change multiple cells at once?
Reply With QuoteReply With Quote