Automating a workbook ???

[inktec]

Hi

I am currently trying to develop a workbook with which I intend to capture data in the customer details sheet as shown, these details should then automatically reflect in the registration sheet. Once all the detail is captured in the customer detail sheet, I wish to be able to by way of a submit button on the customer detail sheet automatically print two copies of the registration sheet and also to e-mail the registration to a selected bunch of recipients including the e-mail address of the customer. Furthermore, the detail shown on the registration sheet should be protected and these attributes should remain in place once e-mailed, even better if the registration sheet could convert and mail as a pdf. Also is it possible to have the sheet name reflect the mnxxx of the relevant customer.

Once this is all done, ideally I would like to move onto mn0002 and repeat the entire exercise. Once printed and mailed the data on the registration sheet does not need to kept, just replaced by the new data as the lines in the next customer details row is completed.

As seen in the attachment, I have managed to get the data to replicate in the registration sheet, but have the following problems.

When I move to the next row in the customer detail sheet i.e. mn0002, the data will no longer reflect in the registration sheet. Also it is beyond me if at all what I have described above can be automated. Any help whatsoever would be most appreciated.

Thanks,

John.