Copy Filterd Data from worksheet to another workbook template

G

Guest

I have a worksheet that has account info on it. It has about 11 columns on
it. After I filter the data with a command button (filter is built), I need
to select certain columns of the data and copy it into another workbook
template. How do I select data out of certain columns and then send it to
another workbook?

Please Help and thanks!
 
D

Dave Peterson

Turn on the macro recorder while you do it manually.

Filter to show the rows you want to see
copy the visible rows (avoid the headers)
paste into the other worksheet
stop recording the macro.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
VBA - retrieve data on last create named range from previous inserted named range 0
sending data to a template 1
save worksheet as another file, but have all defined names copied 1
Copy sheet to different workbook sizing error message 2
move a worksheet from one workbook to another 1
Using VBA to copy data into another worksheet ??? 2
Macro to push data to another workbook 0

Top