I am looking to have a macro which will copy all the rows from A11 to the next blank row, allowing for different amounts of data. For example I could have the following ranges:
A11 - A21
A11 - A33
A11 - A42
But will always have a blank row at the end of the range I wish to copy.