Righty ho, have no clue about excel macros and suchlike so figured why not ask here!
Basically I'm preparing an excel workbook with monthly target sheets in, with a different sheet for each month. Whilst it would be easy to have Month 1,2,3,4 etc, that's apparently too hard
o) and the sheets need to be named after the actual months, but people have different start dates and so different start months.
I was thinking I could have a cell with Month 1 (say November) generate a 12 month list and then run a macro to apply that list to the sheet names, however I've no idea how to do this...!
Any ideas if this is possible much much much appreciated!
Cheers!
Basically I'm preparing an excel workbook with monthly target sheets in, with a different sheet for each month. Whilst it would be easy to have Month 1,2,3,4 etc, that's apparently too hard
o) and the sheets need to be named after the actual months, but people have different start dates and so different start months.I was thinking I could have a cell with Month 1 (say November) generate a 12 month list and then run a macro to apply that list to the sheet names, however I've no idea how to do this...!
Any ideas if this is possible much much much appreciated!
Cheers!