Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merge two worksheet with same criteria
Hi,
Can somebody help me with this request. I need to have a macro to merge and join the names of sheet 1 and 2 in a new sheet. If a name appears on both sheets, each number on Sheet1 and Sheet2 with the same name must be indicated in a separate column next to the name. If a name exists in sheet 1, it must still be added to the new sheet with the corresponding number and vice versa for sheet2. I am new with VB code and I don't know how I can do it Thanks Catherine Sheet1 Column A Column B Name Number 1 a 2 b 3 c Sheet2 Column A Column B Name Number 1 c 2 d 4 e NewWorksheet Column A Column B Column C Name Number Sheet1 Number Sheet2 1 a c 2 b d 3 c 4 e |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I merge duplicated data in rows with different criteria | Excel Discussion (Misc queries) | |||
code to merge cells with criteria | Excel Programming | |||
How to merge columns from one worksheet to another worksheet | Excel Worksheet Functions | |||
Selection.AutoFilter Field / Criteria = criteria sometimes non-existing on worksheet | Excel Programming | |||
How to merge more than one worksheet | Excel Worksheet Functions |