Copy paste dynamic values after every minute

[Shek_2]

Hi All,
I have a limited knowledge on macros.
The macro in this attached excel works exactly how i wanted, however when i run for 300 rows, it becomes very slow.
Can anybody help me to run the macro faster.

Thank you

[Kaper]

Start from this change:

Please Login or Register  to view this content.

So instead of making nested loops reading and writing cell by cell read and write whole ranges.

You can also add

Please Login or Register  to view this content.

at the beginning of sub and = True at the end

[Shek_2]

Dear Kaper,
Thank you so much for taking time to solve my problem. I had tested it and it works perfect.
I don't forget the name Kaper from Poland.