I have a sheet with only 20 rows with range A1:A20 to insert data, that gives me one printting page.
My idea is every time I have 20 ranges with data the macro automatically copy a row 10 rows above (hidden, with no data, only with my formulas. In between I have the colums results) and insert 20 new rows abobe de other 20 first rows.
I already found how to copy and insert rows.
1-My problem is run the macro automatically
2-Continued inserting 20 rows after I have a printting area filled knowing that every time I insert 20 rows the row to be copy is no longer de row 30 ( 10 above de first 20) and the row to copy the hidden row is no longer de row 21.
My idea is every time I have 20 ranges with data the macro automatically copy a row 10 rows above (hidden, with no data, only with my formulas. In between I have the colums results) and insert 20 new rows abobe de other 20 first rows.
I already found how to copy and insert rows.
1-My problem is run the macro automatically
2-Continued inserting 20 rows after I have a printting area filled knowing that every time I insert 20 rows the row to be copy is no longer de row 30 ( 10 above de first 20) and the row to copy the hidden row is no longer de row 21.
