Using VBA to copy a range of data from one sheet to another

[GrahamButler1970]

I am trying to copy data from one sheet to another sheet using autofilter.

What I currently have is 4 macros which autofilter a sheet of data.

What I need to do is do this and then copy the results to another worksheet in that workbook and then paste the results under each other. Therefore, finding the next available row and coopying the data there.

I only need to copy the data under the headers in Row 1.

The 4 macros' I have also do copy a range of data but that is specific to that test data I have and it does not select the range of visible cells that will come with later datasets.

Any help??

 

[JamesW]

Hi,

Have you tried the "Select Visible Cells" button? (You may need to add it to your tool bar: Right click on a toolbar, click Customize, goto Edit, scroll down and drag "Select Visible Cells" to your toolbar).

You basically Highlight the filtered data, click that button, Ctrl + C and then paste it into your new sheet. The data should be in a nice order.

 

[GrahamButler1970]

Thanks for that.

I have 4 macros to run. How do I ensure that when I copy the data it finds the next available row to autopopulate.