help required for formula to copy a worksheet using a cell refferance

[charlieonebravo]

Hi,
i require with the below if possible. We are still running the 2003 version of excel and I need to be able to open a template and once completed it save as a new sheet. The problem I have with the macro is I need it to save from a cell ref, so for example if cel A1 had "ABC123D" the macro or formula would save the sheet as ABC112D.xls any help would be great thanks

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.