Atomatic timesheet creation for individual employee from one master sheet

[Imtiyazd]

Dear Friends,

I just joined this forum and found it so useful with great talents from member about MS Excel.

Hoping somebody can help me out with this problem that I struggled to figure out how to come up with solution for preparing monthly time sheet for each employee from master sheet automatically by entering details in master sheet (Master sheet is all employees attendance sheet).

Just by entering data in master sheet it need to copy data to individual employee sheet. If I enter new employee name in master sheet can it creates one new sheet with same format by itself?

It's somehow complicated and I don't know if it's possible.

Data are
Project, Emp Name, Position, Date, Day, Time In, Time out, Overtime or under time (if any)

I have total 30 employees and it is increasing day by day

Please, all ideas will be highly appreciate. I don't know how can I post the sample sheet itself to make it clear.

Regards,

 

[dmt32]

Hi welcome to the board.

It would be helpful if you could place copy of your workbook with sample data in a public dropbox & the provide a link to it.

This will then give the board better understanding of what you are looking for.

Hope helpful

Dave