Hi,

I need to sort some data stored in 3 colums to match another sheets data.

Sheet 1

Ref No's then 3 colums of data
012345
023456
034567
045678

Sheet 2 - same refs but in different order with 3 colums of data

023456
012345
034566
034567

How can I match sheet 2 to be in same order as sheet one with, and this is
the important padr the 3 colums of sheet two to be sorted by their ref
numbers??

HELP PLEASE!!