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