Pasting the entire rows in another sheet
Closed
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.
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.
Related:
- Pasting the entire rows in another sheet
- Sheet right to left in google sheet - Guide
- Windows network commands cheat sheet - Guide
- Mark sheet in excel - Guide
- How to open excel sheet in notepad++ - Guide
- How to screenshot excel sheet - Guide
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
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!
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!
Jan 12, 2009 at 11:36 PM
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