I have a random list of dates with quantity ordered along with other
data in a worksheet.
I would like to transfer the date and quantity ordered only over to
another worksheet in date order.
so original sheet will have
cell A6 03/04/05 cell A7 will have 8
cell B6 03/03/05 cell B7 will have 6
cell C6 01/04/05 cell C7 will have 12

In the new sheet i want the resul to show
cell A1 03/03/05 cell A2 will have 6
cell B1 01/04/05 cell B2 will have 12
cell C1 03/04/05 cell C2 will have 8

Can someone show me an example please.
Thanks for any help


--
foilprint0
------------------------------------------------------------------------
foilprint0's Profile: http://www.excelforum.com/member.php...fo&userid=6245
View this thread: http://www.excelforum.com/showthread...hreadid=507153