Copy Filterd Data from worksheet to another workbook template
 

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!

Copy Filterd Data from worksheet to another workbook template
 

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.



Kenny wrote:

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!

--

Dave Peterson