Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
matching two columns in two separate sheets against one another...
What i have:
I have three different spreadsheets; one with all of the bilingual employees of a company and their qualifications, another is a list of all the terminations for that company, which i get monthly but i have a backlog because no one has done it in the past three years (which is a substantial number) and the last is a spreadsheet which is now blank but with the same format as the first spreadsheet mentioned. What i want to do with what i have: I want to use the second sheet mentioned earlier as the search criteria (i want to search by first and last name) and i want to search for names in the rows of the bilingual sheet that match the first and last name of someone in the terminations sheet and then have the row in sheet 1 marked (maybe highlighted) so i can cut the name out of the bilingual sheet (or it can be cut out of the first sheet sheet and pasted to the third sheet automatically, which would be easier). and put it in the third sheet which will serve as a storage sheet for terminated employees so that if we get sued i'd still have that persons qualifications information to cover me. -- thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
matching data on two separate worksheets | Excel Discussion (Misc queries) | |||
How do i distribute columns of data to separate sheets? | Excel Worksheet Functions | |||
find a cell matching separate column and row values | Excel Worksheet Functions | |||
I wish to separate city, state, and zip into 3 separate columns | Excel Worksheet Functions | |||
want to find two matching answers governed by two separate equatio | Excel Discussion (Misc queries) |