Hi
I have a list of employees in Sheet 1 which is a summary of Sheet 2.
Sheet 2 has list of employees with their dates (1,2,3...) and hours, in a seperate row whereas sheet 1 is a summary of employees worked in a particular month based on sheet 1.
Sheet 2 is a download paste values standard format every month.
The name of employees is standard working on a project but sometimes a new employee may be added in Sheet 2. Is it possible that a macro can be created which finds a new employee in Sheet 2 and add a new line in Sheet 1.
Thanks
I have a list of employees in Sheet 1 which is a summary of Sheet 2.
Sheet 2 has list of employees with their dates (1,2,3...) and hours, in a seperate row whereas sheet 1 is a summary of employees worked in a particular month based on sheet 1.
Sheet 2 is a download paste values standard format every month.
The name of employees is standard working on a project but sometimes a new employee may be added in Sheet 2. Is it possible that a macro can be created which finds a new employee in Sheet 2 and add a new line in Sheet 1.
Thanks
