Excel urgent

Closed
milan - May 14, 2010 at 03:38 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 14, 2010 at 06:48 AM
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 January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 14, 2010 at 06:48 AM
Have you tried to use excel macro recorder? It can give you a template that you can modify to fit your needs
0