View Single Post
  #1   Report Post  
Dave T at home
 
Posts: n/a
Default Define Names in Excel

Insert - I have a workbook for each month of the year. I have named cells
in the workbook e.g. DT_Inc_Jan_Pupil_Hourly_Cash and DT_Exp_Jan_Fuel_Cash.

I have pasted the names into a workbook.

I would like to copy these NAMES and do a replace from '_Jan_' to '_FEB_'
etc as I need an entry for each month and then Define them in Names.

Can this be done easily without adding each entry in Insert - Name -
Define or can someone help me please with an easier / better method?

Thanks

Dave