Neil

That's not a lot of info to go on, but here's what I'd do. Create Form B
manually and hide the worksheet. When your code calls for a Form B to be
created, copy the hidden worksheet and make it visible. Then fill in
whatever information you need.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

neil wrote:
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.