Two worksheets, One common key - Combine?

[jmh2008]

Two spreadsheets in a workbook (master and updates). One column in common "Last Name". I want to check if the "Last Name" is in "Updates", if so, copy the new columns data from "updates" and append to the end of the columns in Master to the matching "Last Name". So the Master will have all the data related to the one person.

Thanks so much for your help.

 

[AlphaFrog]

Consolidate data in multiple worksheets
http://office.microsoft.com/en-us/excel/HP100952491033.aspx

 

[jmh2008]

I need to copy text. The consolidation works for numbers, but I'm just copying text. I can't see where to do this.

thanks,