Filtering info to corresponding sheet

[Ron de Bruin]

I think your filter items have characters in them that are not allowed in a sheet name or
they are maybe to long ?

If not send me your test workbook private and I take a look at it when I am home from work tomorrow

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

 

[JC]

Ron here is my email (e-mail address removed) send me yours and i can get a test
wkb for you tommorrow so you can see what I am doing. Thanks

 

[Ron I really need your help!!]

Note: I suggest that you not use the code that John posted

Read why on this page
http://www.rondebruin.nl/copy5.htm

Read this:
Do you wonder why I only use AdvancedFilter in the code to create the unique list and
not use xlFilterCopy to filter and copy the data to a new sheet or workbook ?
The reason why I use AutoFilter for that in the code is that there is a bug in xlFilterCopy
It will not copy the correct data when you have duplicate headers in the first row of your data.
Now with 16000+ columns in Excel 2007 the chance that this will happen is much bigger.

 

[Ron de Bruin]

Here is my mail address
http://www.rondebruin.nl/

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm