I have many cells that I have locked within my worksheet. I want to narrow
the amount of data that can be altered by the users for on this timesheet.

On some days - I have employees that charge their time to more than one
labor cost code.

Ideally - I would like to be able to set up some kind of macro or command
button that would add a new row with the previous rows data already
populated. For instance - the date, duty hours, etc. I would also like to
to carry over the formatting for the calculations I've set up. EVEN better
would be if this process would automatically happen when the total hours for
that day entered do not come to 8, 10, or 9 (depending on the person).

At a minimum - I would like to allow them to manually enter a new row. I
can set the protection up to allow user to add a row - but once the row is
added... the locked cells are blank and the user cannot enter any data into
them. I would need to allow for that some way.

Thanks!