Q: I have written an Excel macro that copies a column of data on Sheet1 and pastes that data as a row on Sheet2. However, I want the paste location to drop down to the next blank row each time I paste ...

In this article we will show you an example of a Macro that can copy data in the next blank cell. Using this example you should then be able to apply the solution to a specific problem that you have.