In a way yes. The way it works so far is you fill the details you need onto the purchae order sheet and if necessary the continuation sheet.
On clicking print it will print purchase order then ask re continuation sheet. If no continuation sheet it then transfers the data request to the summary shh
et. Once this is all doneit copies purchae order and cont sheet to a new workbook an asks what you want to save it as and the new book closes. Then the purchase order and cont sheet are cleared of certain contents to make it ready for a new one to be filled in.

What I need to do is to go into the created workbook and at anytime amend this and ensure the summary sheet on original sheet is filled in.

This all works but only if I manually add the module with code for newly created workbooks to those workbooks when I reopen them.

If the module transferred automatically it would work a treat.

Am only dong it in excel because my company will not give the department that wants this the access to Microsoft access ( where it would have been a lot simpler.

I hope this clarifies what I am trying to achieve. I am so close with all the help from you and a few others on here.

I'm hoping it is possible

thanks again for all your help so far.
Libby