Hi All,
I have searched but was unable to find what I was looking for. I have a set of rows that I have copied in an Excel table. I then want to insert these copied rows every 40 lines but with a user input box that lets you choose which row to start at. For instance user can input row 45 and copied rows will be inserted there, then move down 40 rows and insert again and repeat until Col B is blank. Any help would be greatly appreciated, I am still learning to use loops.
Thanks!
I have searched but was unable to find what I was looking for. I have a set of rows that I have copied in an Excel table. I then want to insert these copied rows every 40 lines but with a user input box that lets you choose which row to start at. For instance user can input row 45 and copied rows will be inserted there, then move down 40 rows and insert again and repeat until Col B is blank. Any help would be greatly appreciated, I am still learning to use loops.
Thanks!