View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rachel Costanza Rachel Costanza is offline
external usenet poster
 
Posts: 2
Default Hard code month in Excel

I have a excel workbook with 15 worksheets and every month when I produce the
annualized turnover I have to go into each header on each sheet to update the
month. Do you know of a way using VB or a DATE FUNCTION I can automate the
template to have the current month in the header? For example: Turnover
October 2008

Best,

Rachel