I have a spreadsheet that is linked to another spreadheet. Each month I need the name "Template" replaced with another name for eg Sept2006, Oct2006 etc.
The worksheet name is F & I Comm.
The range will never Exceed A1:Z200.
I feel that it would be easier to set up a prompt that will force the user to enter the month and year into E1 and then to use the data in E1 to replace the name template (full name of original file ='[MONTH END.New Vehicles.Template.xls]STATS'!$G$15-Only the word template to be replaced)
I need to set up VBA code force the user to enter the Month and Year and then will use the Month and Year that has now been entered into E1 to replace the word template
Your assistance will be most appreciated
Howard
The worksheet name is F & I Comm.
The range will never Exceed A1:Z200.
I feel that it would be easier to set up a prompt that will force the user to enter the month and year into E1 and then to use the data in E1 to replace the name template (full name of original file ='[MONTH END.New Vehicles.Template.xls]STATS'!$G$15-Only the word template to be replaced)
I need to set up VBA code force the user to enter the Month and Year and then will use the Month and Year that has now been entered into E1 to replace the word template
Your assistance will be most appreciated
Howard