Previous Topic Next Topic

Auto insert new row and copy data from cell above

Closed
Zalast69
Posts
1
Registration date
Thursday March 9, 2017
Status
Member
Last seen
March 9, 2017
 - Mar 9, 2017 at 03:41 PM
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