Hi Excel Forum,
I am currently using a macro that copies a set of 5 rows and pastes them after the last row with data in it on the same page.
The code i am currently using is -
I was wondering if it was possible to adapt this code that that it changes the row refrence in column b up 5 everytime the macro is used for example. Cell formula reference changes from B:10 to B:15 then B:15 to B:20, i hope that makes sense.
I also was wondering if it was possible when it adds the new rows it also asks what worksheet you would like to connect the formulas to. As the new row will link to the same Columns and Rows but just on a different Tab.
I hope this makes sense i find it a bit hard to explain myself.
Thanks
I Hope someone can help
James
Bookmarks