View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
L. L. is offline
external usenet poster
 
Posts: 4
Default find & replace??

Every year I run into same problem/inconvenience.

Have a spread sheet set up with 12 monthly pages named Jan 200x, Feb 200x +
recap sheet and income sheet.

The first year this was setup was 2005.

Last year I manually renamed all pages and formulas to 2006.

Is they a "better/easier" way of changing all the 2006 to 2007?

L.