| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge 2 Excel sheets
There is a lot of information in each sheet and they need to be merged.
Each sheet had a unique ID which matches with each other (ie one sheet hadd addresses and the other has the phone number and they need to be merged onto one line to be inported into a database.) Can someone please assist thanks in advance. Michael |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge 2 Excel sheets
Have a look at VLOOKUP in Help and then come back if more help is needed
But give as more details on your worksheet layouts best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Michael" wrote in message ... There is a lot of information in each sheet and they need to be merged. Each sheet had a unique ID which matches with each other (ie one sheet hadd addresses and the other has the phone number and they need to be merged onto one line to be inported into a database.) Can someone please assist thanks in advance. Michael |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I merge info. from 2 sheets using common numbers in Excel? | Excel Worksheet Functions | |||
| I have 100 excel sheets how can I merge all data into one sheet | Excel Worksheet Functions | |||
| merge data in different excel sheets of same format in one sheet | Excel Worksheet Functions | |||
| How can I merge and purge two excel work sheets? | New Users to Excel | |||
| How can I merge multiple sheets from different Excel files workbo. | Excel Worksheet Functions | |||
Linear Mode
