Hi,

I have created a quote template spreadsheet which creates a finished quote from the information entered into the cells within a sheet called 'Input Screen'. I also insert a picture into a sheet called 'Quote Start', there are other picture already within this sheet. Then I have a macro which runs(button) to copy and paste the values of certain cells that have been entered in the input screen on to another sheet called 'sheet1'. I do this list to create a 'quote list' of all the previous quotes I have produced (each time I run the macro it copy/paste the information to a new row), but to keep this list current every time I use the template I have to save the completed quote to a new location and then clear all the information I have entered into the cells on the input screens and delete the picture I inserted and then save as the original quote template file name (Called 'Quote Builder') which is always in the same location (this location is 'Renewables(\\PDC) (R Quote Template').

I am looking for a macro which will clear all the information from the input screen, delete the picture I have inserted and save the template to the original location. I kind of need it to restore to when I first open the template but leave the information I have copy/pasted into the quote list.

Is this possible?

Cheers

Jon