Copy Filterd Data from worksheet to another workbook template

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
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.
 
Back
Top