Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
matching 2 worksheets together
Hi! I have two worksheets that have one field in each that may match. Each worksheet has a different number of rows. They are not sorted and some cells may not contain any data. Need to match and sort by column D in this example. Example Sheet 1 A B C D 234 widget 44 LD2M34 567 gadget 76 LD2M76 789 top 39 LD2M95 Sheet 2 A B C D BLDG1 75 99 LD2M95 BLDG4 45 27 LD2M34 Desired Output in third worksheet A B C D E F G H 234 widget 44 LD2M34 LD2M34 BLDG4 45 27 789 top 39 LD2M95 LD2M95 BLDG1 75 99 567 gadget 76 LD2M76 The sheets I'm trying to match contain between 200 to 3000 rows. Thanks in advance! Ray -- RayB ------------------------------------------------------------------------ RayB's Profile: http://www.excelforum.com/member.php...o&userid=33499 View this thread: http://www.excelforum.com/showthread...hreadid=559443 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
matching 2 worksheets together
Example Hyphen between columns Sheet 1 A -B -C -D 234 -widget- 44 -LD2M34 567 -gadget -76- LD2M76 789 -top -39- LD2M95 Sheet 2 A -B -C -D BLDG1 -75- 99- LD2M95 BLDG4 -45 -27 -LD2M34 Desired Output in third worksheet A -B -C -D -E- F- G -H 234 -widget- 44 -LD2M34- LD2M34 -BLDG4 -45 -27 789 -top -39 -LD2M95 -LD2M95 -BLDG1 -75 -99 567- gadget -76- LD2M76 -- RayB ------------------------------------------------------------------------ RayB's Profile: http://www.excelforum.com/member.php...o&userid=33499 View this thread: http://www.excelforum.com/showthread...hreadid=559443 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding matching fields accross multiple worksheets | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
MATCHing through multiple worksheets | Excel Worksheet Functions | |||
finding matching cells in worksheets | Excel Worksheet Functions | |||
Find matching records in two worksheets | Excel Discussion (Misc queries) |