Updating worksheet and move data to another worksheet

Hi Chiss,

There is always a way...

Sorry, there was a simple fundamental flaw in the code.

Hopefully (fingers crossed) the attached should work for you this time.

Again let me know if it works (or doesn't work), I'm sure we can get to the bottom of this!

Owen