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 |
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 |
All times are GMT +1. The time now is 01:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com