Automate export to a new workbook
 

Hello!

I need to make some filtered data available to Word for mail merging.
As I understand it, mail merge only see the first sheet in a workbook,
and the ability to extract data to a separate workbook is neat
regardless.
Is there any way to do this automated, or user initiated (not user
executed).

I expect I may need to use macros, but i've never used a macro in
Excel. Be gentle.. ;o)

I need data filtered by three columns, by the way, and to different
filenames based on filter criteria.

- Atle