I want to automate the process of applying some formatting contained in a
template to a worksheet created based on certain conditions.

By meeting a certain conditions in Form A, Form B is created and
automatically formatted and at the same time populating four key fields in
the newly created Form B, once this is done the user can complete the newly
created form. It is possible to have more than one Form B, so the process
will have to be repeated.

Any ideas would be appreciated.
--
neil