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!