waldo123
04-08-2010, 09:09 AM
Good morning,
I am looking for a way to step through an autofilter and copy and paste the results (edit: visible cells) into new, separate sheets. So the sheets have to be created, preferably with the name of the criteria being used.
I have 7 criteria which are fixed, but in case I add another I'd prefer to have the macro just step through the criteria. The autofilter is on just one column.
I found these pages:
http://www.vbaexpress.com/forum/showthread.php?t=14611
http://www.vbaexpress.com/forum/showthread.php?t=25730
Any help is very much appreciated.
Thank you,
Ed
I am looking for a way to step through an autofilter and copy and paste the results (edit: visible cells) into new, separate sheets. So the sheets have to be created, preferably with the name of the criteria being used.
I have 7 criteria which are fixed, but in case I add another I'd prefer to have the macro just step through the criteria. The autofilter is on just one column.
I found these pages:
http://www.vbaexpress.com/forum/showthread.php?t=14611
http://www.vbaexpress.com/forum/showthread.php?t=25730
Any help is very much appreciated.
Thank you,
Ed