Automating a workbook ???
 

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.


--
inktec
------------------------------------------------------------------------
inktec's Profile: http://www.excelforum.com/member.php...fo&userid=7415
View this thread: http://www.excelforum.com/showthread...hreadid=558855