Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
import/export data from a workbook ajn Excel Discussion (Misc queries) 1 December 8th 06 01:44 PM
Automate Import/Export Steve Excel Discussion (Misc queries) 0 October 14th 05 06:38 PM
Automate Export from Form Template to Seperate Table QuestDave Excel Discussion (Misc queries) 0 August 31st 05 05:25 PM
Export TextBox contents to new workbook. Andy Tallent Excel Discussion (Misc queries) 0 February 22nd 05 01:49 PM
Automate Excel to powerpoint - Graphs along with Datasheet (not workbook) Hari Prasadh Charts and Charting in Excel 4 February 17th 05 02:44 PM


All times are GMT +1. The time now is 05:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"