Improve working, but inefficient code

[gnoke]

Hi all,

I use the following code:

Please Login or Register  to view this content.

It works, but it would take about a week to let it run through:p
I am no expert in writing codes, and would be most greatful if somecould could assist me in rewriting it into a more efficient code

Gnoke

[davesexcel]

Possibly a Filter macro for each sheet instead of looping through 18k rows would make a big difference.
No way to tell without a sample worksheet though.