hello, I have looked but can not seem to find.
I need a macro that will insert a new blank row row below and copy cell A10 from above and paste it to new blank row A11 do it automatically every minute. it continues to insert new blank row and copies the data in cell A10.
example:
A10 = 1.056
new row = A10
new row = A10
new row = A10
new row = A10
etc ........
the A10 cell will change value every min
Thank you
