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

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

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

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.

---
Per

"JLum" skrev i meddelelsen
...
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!!