| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging two worksheets that have a common field
Have a look at the VLOOKUP function in Help
Then come back with more details of how the data is set out in you two files your two files best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "lmirrim" wrote in message ... How do I go about merging two Excel 2007 worksheets (in the same workbook) into one master list? I want to connect them using a common field, say, LAST NAME. How can I do this to create one master worksheet? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to combine two worksheets into one. Only ONE column is common. | Excel Discussion (Misc queries) | |||
| combining two spreadsheets with a common field | Excel Discussion (Misc queries) | |||
| Merge rows from 2 XLS files using a common key field. | Excel Discussion (Misc queries) | |||
| Add data based on a common field | Excel Worksheet Functions | |||
| Compare two worksheets and identify common entries | Excel Discussion (Misc queries) | |||
![Bernard Liengme[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
