Copy a selected range based on cell criteria

Hi guys,

Tried several ways in order to fix my problem, but I can't seem to get it to work.

I have a worksheet in which I want to select a certain range of cells, I then need it to filter in the last row of the selection for the word "Incompleet".
Then it should copy the selected cells which are in front of the cell it filtered from and then past it into a different worksheet named "Incompleet" in the next empty row. This is what I have so far;

Please Login or Register  to view this content.

The column it must filter from will always be the 9th column, even though the selection can be made from anywhere within the worbook.

I have the idea that I'm very close, but there seem to be some problems with the copying after the autofilter has taken place.

Thanks in advanced for your help guys!!

Test.xlsm