Form A is a timesheet with default hours and default time allocations to
activates 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 worksheet "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 surprisingly.

My Visual Basic skills are lets say rather basic so any help or advice would
be appreciated.

--
neil