Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

Hello,

I have got dates typed in the format following 01.08.98 and I want to change it to 01/08/1998 format. I tried applying the format we have in excel format cell date format but nothing is happening.

Please help me on this.

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

Hello,
hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i have students total marks.now I wanna get the 1st 2nd 3rd...so on position of student leads from highest to lower one...

regards
hardy

6 responses