Filtering info to corresponding sheet

R

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
 
R

Ron I really need your help!!

Ron de Bruin said:
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.
Click to expand...
 
Top