Excel urgent

Closed
milan - 14 May 2010 à 03:38
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 14 May 2010 à 06:48
hi. This is possiable?
i have a, large amount of employee data .sometime some employee runaway,or after vacation not come back.in this case i want to do.
1 when runaway or not come back this name this name/row should be go to another sheet(sheet2)
2. when the name/row go to another sheet.first sheet(sheet1)row should be delete.
Basically, i just change row colour to know this.
there is my eg.file
https://authentification.site/files/22426686/employee.zip
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
14 May 2010 à 06:48
Have you tried to use excel macro recorder? It can give you a template that you can modify to fit your needs