VBA: Copying row to new workbook based on condition

[yalie]

Hi all,

In my current workbook, I have a table as follows
A B C D E
1 # @ xx ?
2 # @ yy ?
4 # @ zz ?
5 # @ ww ?

Looking at column D, I need to export rows with xx and yy to a new workbook, and zz,ww each to its individual workbook (new)
So 3 new workbooks total.

Thanks in advance for your help.

 

[VoG]

Try Excel Explosion http://www.datapigtechnologies.com/freeware.htm

 

[yalie]

thanks.
But do you actually have a script for vba script for what I'm trying to do?
Because I want to add in script so that once the data is parsed into different workbook, i want to email out the workbook to a list of recipients.

thanks.

 

[VoG]

Try this (scroll down a bit) http://www.mrexcel.com/forum/showthread.php?t=396069