The following further explantion may help.

Form A is a timesheet with default hours and default time allocations to
activites for 20 employees, if the employee works the default hours by
clicking the column header the indicator "A" is put in column 9 if not the
user should click the column header for column 10 the indicator "B" is put
automatically into the active cell and form B is created from a template
populated with that particular employees details, the user then enters the
revised timesheet data into Form B1. Once finished with that employee the
exercise is repeated for all employees on Form A. It is the "Form B process
I am having trouble not suprisingly.

So I would appreciate any help

thanks

Neil

"Dick Kusleika" wrote:

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.