PDA

View Full Version : Autofilter, copy-paste to new sheet



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

GTO
04-08-2010, 09:22 AM
Greetings Ed,

I think it would be easier if you could attach an example wb. The layout and filters to reflect, with fake/non-sensitive data.

Mark

waldo123
04-08-2010, 09:44 AM
Mark,

Thanks for the advice, uploaded a file.

Rgs,

Ed

mdmackillop
04-08-2010, 12:01 PM
All of the headers are the same. There is nothing to show what you want to filter and the "criteria" bear no relation to the data. A sample on which code can be tested is much more useful.