Dear Excel Guru's,

I am in need of your help. I have spent hours searching forums for a similar problem to mine and can not apply the answers to my problem.

I have a column of exchange rates, B5:B46 sheet 1,that updates hourly via msn money. I would like this list to be copied to a row in sheet 2, A2:AP2.

In addition I also need each new update of exchange rate column (B5:B46, sheet 1) to be copied to the row below the previous in sheet 2, e.g. A3:AP3 in hour 2, A4:AP4 in hour 3, A5:AP5 in hour 4... and so on and stop at hour 48 A49:AP49, at which the process will repeat (starting from A2:AP2 again). FX.xlsx

The aim is to have 41 lists (for 41 exchange rates) of the hourly change in exchange rates for the past 2 days, that updates automatically.

To add to this challenge I am new to macro (but not clueless), so as much detail would be very appreciated.

I would be so grateful for any help or advice. Thankyou in advance.