View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Richard Buttrey
 
Posts: n/a
Default Slow data filtering

On Sun, 29 Jan 2006 18:03:18 -0800, rudawg
wrote:

Richard,

I am glad you solved your issue.........In reading your post, it appears you
were having trouble with something similar to what I am trying to do. In
this same forum, I have posted a question titled "Filtered List to New
Worksheet". Would you review that question and let me know if it is similar
to what you are succesfully doing in your workbook.

Thanks
Rudy


Although I'm doing a lot more than your task, the bit about filtering
is exactly the same. The only difference being that I'm running a
filter with a macro looping about 400 times to get 400 filtered sets
of data, whereas you're doing it manually. My problem was that I'd
seen a big increase in time which I couldn't understand.

However I've posted a response over in the other thread.

Hope it helps,

Rgds


Richard Buttrey
__