View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
atledreier atledreier is offline
external usenet poster
 
Posts: 13
Default 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