Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I apply a template to one worksheet in existing workbook? | Excel Discussion (Misc queries) | |||
Copy Data from Workbook into specific Worksheet in other Workbook? | Excel Discussion (Misc queries) | |||
Macro or OLE method to insert worksheet from template workbook | Excel Discussion (Misc queries) | |||
copy data from one worksheet to identical sheet in different workbook | Excel Discussion (Misc queries) | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions |