| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data entered from list automatically enters number in another cell | Excel Worksheet Functions | |||
| Running a Macro that enters a function that returns #VALUE! | Excel Discussion (Misc queries) | |||
| Getting valid web searches and avoiding sites that contaminate web searches | New Users to Excel | |||
| Record a macro which enters a password to unprotect a workbook | Excel Programming | |||
| Macro enters formula but it won't calculate! | Excel Programming | |||
Linear Mode
