It's not the whole solution (maybe not even part of the solution?), but
if you start with an advanced filter, you can specify which value for
column F you want transferred to another sheet, then it will move all
records that have that value in F to another sheet in the workbook.
Then you move the new sheet to a new book and save that book. All of
this can be done in VBA, I just haven't taken the time to write the
code.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=377809