Auto insert new row and copy data from cell above [Closed]

Registration date
Thursday March 9, 2017
Last seen
March 9, 2017
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.

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!