J
jcontrer
I have a two spreadsheets in the same workbook named:
LAWSON
column a: EEID column b: LASTNAME column c: FIRSTNAME
Bi-Lingual Skills
column a: IDNUMBER column b: NAMELAST column c: NAMEFIRST
all of the names in the lawson sheet are in the bi-lingual skills sheet (but
not vice versa) yet the lawson sheet has the employee id's and the bilingual
sheet doesn't and i need those to be transferred from one sheet to the other
(prefferably through a macro).
In essence i would like help with a macro that searches for first and last
name from the lawson sheet that also appear on the bi-lingual skills sheet
and then copy the employee ID (EEID from lawson sheet) into the bilingual
skills sheet (under IDNUMBER)for those that match first and last name.
please help, it's reporting time and i need this in order to get anything
done!
LAWSON
column a: EEID column b: LASTNAME column c: FIRSTNAME
Bi-Lingual Skills
column a: IDNUMBER column b: NAMELAST column c: NAMEFIRST
all of the names in the lawson sheet are in the bi-lingual skills sheet (but
not vice versa) yet the lawson sheet has the employee id's and the bilingual
sheet doesn't and i need those to be transferred from one sheet to the other
(prefferably through a macro).
In essence i would like help with a macro that searches for first and last
name from the lawson sheet that also appear on the bi-lingual skills sheet
and then copy the employee ID (EEID from lawson sheet) into the bilingual
skills sheet (under IDNUMBER)for those that match first and last name.
please help, it's reporting time and i need this in order to get anything
done!