| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare 2 lists and merge
Hi, Could someone help please, I have 2 worksheets 20 columns in each (both sheets have identical row headers) and 30-40 rows, in column A of both sheets is a field that may or may not appear in both sheets, what I would like to do is merge the information from both sheets and create a master list in sheet3 is this possible? I have attached a sample workbook if this helps! Regards, Sanjay +-------------------------------------------------------------------+ |Filename: merge list.zip | |Download: http://www.excelforum.com/attachment.php?postid=3684 | +-------------------------------------------------------------------+ -- sanjay ------------------------------------------------------------------------ sanjay's Profile: http://www.excelforum.com/member.php...fo&userid=5915 View this thread: http://www.excelforum.com/showthread...hreadid=394780 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare lists | Excel Discussion (Misc queries) | |||
| Compare two lists | Excel Worksheet Functions | |||
| compare two lists | Excel Worksheet Functions | |||
| compare and merge lists in separate worksheets | Excel Worksheet Functions | |||
| Compare Lists | Excel Discussion (Misc queries) | |||
Threaded Mode
