Hiya, I have a time sheet database (Excel 2000) that calculates Time In Leiu (TIL) and sends the info to a specific TIL tab for each employee.

I need to be able to have the "Staff 1 Hours" worksheet automatically populate a second worksheet ("Staff 1 TIL") with the "week ending date" and the "total Time In Leiu" (TIL) that each staff member has accrued. Each staff member has a tab, and his/her TIL info goes to his/her TIL tab.

The "TIL" tab stores a running total of accrued hours in a simple table, and gives me the history of hours accrued (on a weekly basis). I need it to not over-write the previous weeks info, so will need it to automatically insert a new line after the previous weeks entry.

I am very green at Excel programming, and do not comprehend VB. Is there a formula I can use instead of Macro's etc to achieve this?

Please help!!