Hi,

Please help with the below macro.

I have two tabs: Sheet1 & Sheet2

Sheet1 contains the below information:

Columns:

A B C D E

Code From To Amount Group
A1050 1/06/2007 5/06/2007 $ 50,000 ABC
B1060 1/06/2007 5/06/2007 $ 50,000 ABC
C1070 1/06/2007 5/06/2007 $ 50,000 ZZZ


I need to organise these data to Sheet2 in the below format

Columns:

A N Q S

Code Amount Group Date
A1050 $ 50,000 ABC 1/06/2007
A1050 $ 50,000 ABC 2/06/2007
A1050 $ 50,000 ABC 3/06/2007
A1050 $ 50,000 ABC 4/06/2007
A1050 $ 50,000 ABC 5/06/2007
B1060 $ 50,000 ABC 1/06/2007
B1060 $ 50,000 ABC 2/06/2007
B1060 $ 50,000 ABC 3/06/2007
B1060 $ 50,000 ABC 4/06/2007
B1060 $ 50,000 ABC 5/06/2007
C1070 $ 50,000 ZZZ 1/06/2007
C1070 $ 50,000 ZZZ 2/06/2007
C1070 $ 50,000 ZZZ 3/06/2007
C1070 $ 50,000 ZZZ 4/06/2007
C1070 $ 50,000 ZZZ 5/06/2007