Sorry for the confusion. As an old 84 year old fart I can't code like I did
in the Eighties. The code does what I want except that it over writes the
Master sheet to be the same a the new saved sheet

"OssieMac" wrote:

Like Marcus, I was also confused by your explanation. Because I wrote the
original code that you amended to include Inputbox for the appended alpha
character, I am now simply assuming that the ActiveSheet becomes the new
sheet that you want to copy and not the original Master.

Therefore if my assumption is incorrect, you do need to confirm if it is the
ActiveSheet you want to copy or the Master sheet to be copied each time.

--
Regards,

OssieMac