Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging information from two different excel spreadsheets
I am using an Excel 2000 worksheet as a contact list. I have a seperate worksheet that contains two columns, one with names of individuals and the other e-mail addresses. I would like to set up something, that will look at the names on the e-mail address worksheet, check if they match with any names on the contact list, and then insert the corresponding e-mail address in a cell in the next column. I'm not sure if you can do this with two different worksheets or if I need to paste all the cells into the same worksheet. Can anyone help????? -- MAPADMIN ------------------------------------------------------------------------ MAPADMIN's Profile: http://www.excelforum.com/member.php...o&userid=29977 View this thread: http://www.excelforum.com/showthread...hreadid=497649 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging in Excel from Word, Excel, or Access | Excel Discussion (Misc queries) | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
How do I merge excel information with a word document? | New Users to Excel | |||
Setting tab colours on Excel spreadsheets (for Excel 2000) | Excel Discussion (Misc queries) | |||
Sharing information between Access and Excel | Excel Discussion (Misc queries) |