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

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.

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.

Neil

I think my advice is the right way to go then. I'm not sure what else I can
tell you. If you would like to see an example workbook and put one together
and email it to you. Just send me an email requesting it and reply with one
attached.

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

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