Is there any program which would order the data from sheet two as show
on sheet one? i.e. I need to order data from two columns into row
placing the most recent value into sheet 1 in the left hand column o
the row.

(sheet 2)
A 1 B 5
B 3 A 2
A 3 B 1

Producing the table:
(sheet 1)

A 3 2 1
B 1 3 5

Thanks,

Phi

--
phil200
-----------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...fo&userid=3509
View this thread: http://www.excelforum.com/showthread.php?threadid=55176