R
RayB
Hi! Can someone help me!
Thanks in advance.
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
(Hyphen indicate columns for clarity)
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
Thanks in advance.
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
(Hyphen indicate columns for clarity)
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