Filtering info to corresponding sheet

  • Thread starter Thread starter JC
  • Start date Start date
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
 
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 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...
 
Back
Top