matching 2 worksheets together

[RayB]

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]

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- LD2M7