I don't need these because I'm copying the entire row.

"jcontrer" wrote:

These are the Sheet and Column names. Please update the macro beacuse i dont
know what to put where.

sheet 1: Employee Bi-Lingual Skills
Columns: A:LAST B:FIRST C:LANGUAGE D:QUALIFIED E:GENERAL F:HOSPITAL
G:DEPARTMENT H:EXTENTION I:COMMENTS J:INTERESTED K:FLUENCY L:MEDICAL M:SHIFT
N:SPECIAL O:BANK

Sheet 2: Terminated Employees
Columns: same as sheet 1

Sheet 3: New Terminations
Columns: A:Last B:First

So this Macro will search in sheet 1 to see if any names match sheet 3, and
if it then finds a match, it will cut the entire row out of sheet 1 and paste
it on sheet 2?


--
thanks in advance


"jcontrer" wrote:

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