View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Byron720 Byron720 is offline
external usenet poster
 
Posts: 61
Default Updating formulas on workbook

I found out how to do it. In case someone needs to know, just select all
worksheets and do a find a replace

"Byron720" wrote:

How do I change a formula from Oct 08 to Nov 08 in different worksheets all
at once? Example change Oct 08! reference in all formulas to May05! in all
worksheets at once. The workbook contains many worksheets and it takes time
to go thru each page and change it.