macro that searches by first and last and enters id number
 

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!

--
thanks in advance

macro that searches by first and last and enters id number
 

Why use a macro. Insert a column (A) on both sheets. Cncatenate the First and
last names together in this new column. Now you can just use a simple VLookup
formula to associate everything together...
--
HTH...

Jim Thomlinson


"jcontrer" wrote:

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!

--
thanks in advance

macro that searches by first and last and enters id number
 

well, i did the concatenate part but i have never worked with vlookup. what
do i do with the vlookup to get the id's copied from the lawson sheet to the
skills sheet?
--
thanks in advance


"Jim Thomlinson" wrote:

Why use a macro. Insert a column (A) on both sheets. Cncatenate the First and
last names together in this new column. Now you can just use a simple VLookup
formula to associate everything together...
--
HTH...

Jim Thomlinson


"jcontrer" wrote:

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!

--
thanks in advance