Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dave Peterson
 
Posts: n/a
Default Creating multiple workbooks from summary workbook

Maybe you could use the sample code at Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

The code could be modified to use a worksheet in a new workbook, too.


encise wrote:

Anyone out there!? Please don't tell me my first post is the most
difficult query and noone has a solution?!

--
encise

Dr Pepper fan
------------------------------------------------------------------------
encise's Profile: http://www.excelforum.com/member.php...o&userid=28484
View this thread: http://www.excelforum.com/showthread...hreadid=480970


--

Dave Peterson
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
paste formulas between workbooks without workbook link ron Excel Discussion (Misc queries) 3 April 22nd 23 08:11 AM
How can I merge and link workbooks into one summary workbook? Sylvia Excel Worksheet Functions 3 July 31st 08 09:55 PM
Links between workbooks and emailing workbook Leslie Excel Worksheet Functions 4 July 1st 05 02:02 PM
Linking Workbooks Dede McEachern Excel Worksheet Functions 0 January 21st 05 08:27 PM
Creating a subbook from a workbook. Chaplain Doug Excel Discussion (Misc queries) 0 December 19th 04 11:31 PM


All times are GMT +1. The time now is 05:53 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"