Hello,

In the same workbook I have two worksheets:

Worksheet 1 Range("D5:D55") is the range to sort Worksheet 2
Range("B4:C103").

Worksheet 1 - data

Column D
0125
0502
1250
2500

Worksheet 2 - data

Column B Column C
0125 Name 1
0502 Name 2
1250 Name 3
2500 Name 4

How can I use a macro to use worksheet 1 range to sort worksheet 2
range as described above?

Thank you for your help,
jfcby