View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
japc90 japc90 is offline
external usenet poster
 
Posts: 58
Default Changing Multiple Formulas

I have a workbook wih several worksheets. Many of the cells have
similar formulas (the sum of the value of two cells located on a
separate worksheet within the same workbook divided by 390). I need to
change the number 390 in all of these cells to 370. Is there a way to
do this without manually going through every cell?

Thank you.