Pasting the entire rows in another sheet

Closed
Saad - Jan 12, 2009 at 05:59 AM
 Saad - Jan 12, 2009 at 11:36 PM
Hello,

I am making a report where in if the job status of an employee is Resigned or Inservice, so i want all details of that particular employee to be pasted in separate worksheets of active and resigned staff.

the active and resigned worksheets are linked with one master list which consists of all details of the staff.

will really appreciate someones urgent respnse in this regards.

1 response

starsailors.me Posts 24 Registration date Friday August 15, 2008 Status Member Last seen May 19, 2009 12
Jan 12, 2009 at 07:00 AM
hi,
i guess you are working with excel.
place your cursor to the left, near the number bar.
you will notice that the cursir will change from the cross to a bold arrow.
click, and the entire row will be selectd!
0
well i guess u didnt get my question right....

I am working on Ms Excel...In sheet 1, i have a MASTER LIST of all employees including all details....Now i have 2 other sheets named as IN SERVICE and RESIGNED....I want to link these 2 sheets with my Master list in a way that in the master list there is a column of job status(which can have only 2 options as In service or Resigned)

What i want is went i make the job status of any employee as in service, then all details of that employee should automatically be updated in the RESIGNED sheet.....and same for the INSERVICE employees.

I want to LINK the MASTER LIST with the other 2 sheets. HOpe now its clear
0