I have a worksheet F & I Comm, that links data from another spreadsheet.
I need VBA code to be written that will do the following:
1) Prompt the user to enter a date for EG Sept2006 which will be entered into cell E1
2) The date that was enter in cell E1 must be used to relace the word template in all cells in the worksheet "F & I Comm" that contains the word Template ( The full name of one of the linked files is ='[MONTH END.New Vehicles.Template.xls]STATS'!$G$15). I only need the word template replaced in each cell where this appears.
Your assistance will be most appreciated
Howard
I need VBA code to be written that will do the following:
1) Prompt the user to enter a date for EG Sept2006 which will be entered into cell E1
2) The date that was enter in cell E1 must be used to relace the word template in all cells in the worksheet "F & I Comm" that contains the word Template ( The full name of one of the linked files is ='[MONTH END.New Vehicles.Template.xls]STATS'!$G$15). I only need the word template replaced in each cell where this appears.
Your assistance will be most appreciated
Howard