Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / November 2007

Tip: Looking for answers? Try searching our database.

macro that searches by first and last and enters id number

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jcontrer - 30 Nov 2007 14:40 GMT
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!

Signature

thanks in advance

Jim Thomlinson - 30 Nov 2007 16:36 GMT
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...
Signature

HTH...

Jim Thomlinson

> I have a two spreadsheets in the same workbook named:
>
[quoted text clipped - 14 lines]
> please help, it's reporting time and i need this in order to get anything
> done!
jcontrer - 30 Nov 2007 19:40 GMT
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?
Signature

thanks in advance

> 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
[quoted text clipped - 18 lines]
> > please help, it's reporting time and i need this in order to get anything
> > done!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.