I need help of some experts to help me solve this issue. I use RTD function to get live rates, volumes etc from stock market trading software. This info is displayed on a single row on the excel sheet and keeps refreshing every time the rates change and new data is overwritten on the same row. I need a macro / VBA which can help me automatically keep copying this row and paste it on a new sheet by appending a new row. Each time the data is copied it should be pasted on a new row so that the old values are also present. Altough the RTD data keeps refreshing every few seconds, I want that this copy paste loop should be repeated at fixed intervals, say for example every one minute or 2 minutes whatever i choose. If this is possible kindly help me.