Cell range in Sheet1 -- A1 : A15 updates value with forex rate every minute, linked with a DDE external data link.

.

Need to copy each cell value and paste into Sheet2 rows starting from A1:A15 next available empty cell every 5 minutes.

.

Example:

Sheet1/A1 value should be copy/paste to Sheet2/A1,B1,C1,D1 .... continue same row with 5 minutes (time interval may be change)

Sheet1/A2 value should be copy/paste to Sheet2/A1,B2,C2,D1 .... continue same row with time interval define.

.

Any macro for excel 2007 will be great help.

.

Regards,