sorting? do i need a macro....this is not possible!!!

[JLum]

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

 

[Per Jessen]

Hi

As sheet1 is sorted ascending, select all four columns on sheet2 and sort
ascending.

Goto Sort in the Data menu to see how it's working

Hopes this helps.