| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting with a macro | Excel Programming | |||
| Looking for help with a sorting macro. | Excel Programming | |||
| Looking for help with a sorting macro. | Excel Programming | |||
| sorting using macro | Excel Discussion (Misc queries) | |||
| sorting macro | Excel Programming | |||
Hybrid Mode
