Within Curent Macro Save As Unique File Name

[mpand]

I am trying to create a macro button, but I have almost no experience with them so the code is quite confusing.

I have recorded a button which does the following:

• clicks on C1 in sheet1
• copies information from A2 in sheet 3
• pastes information into C1 sheet 1
• clicks on K1 in sheet 1
• copies information from A3 in sheet 3
• pastes information into K1 sheet 1
• copies auto generated information from sheet 1 (generate as a result of C1&K1) into a different template document
• prints selection from template document
• saves template document as new name into a particular folder
• closes new doc
• opens template and clears content (not format) then closes
• clears C1 and K1 in sheet 1
• then when the button is clicked again, move from (A2,A3) to (A4,A5)

I want to:

• loop until the A cell in sheet 3 is blank
• save unique filenames everytime from template file (preferably from a cell in that sheet)

Can anyone help?

 

[CharlesChuckieCharles]

It works best if you Post the Macro code, Gives people something to work with and helps other to understand your request