Move "failed" items to a new worksheet

[James bolton]

Hi all

Need some help with a VBA code I'm trying to generate, see attached I've created an example spreadsheet.

For all failed test items (test 1, 3 & 4 that's everything that says "N", for test 2 thats anything lower than 0.07) I would like to move them all to the next worksheet in one go, using the last cell in ROW A as the range (so that it changes dynamically)

Any help would be greatly appreciated.

Thanks
JOBO

 

[Marc L]

Hi !

Do you really need a code as it can be achieved with few clicks
via an advanced filter ?! (at beginner level)

Anything lower than 0.07 : as column E is %, that means lower than 7% ?
​

 

[James bolton]

Yes

Needs to be code, the actual spreadsheet is much more comprehensive and would just prefer that whenever new fields are imported into the 1st few cells, failed items will be removed in 1 go.

I have actually gone a step further and attached an updated spreadsheet. I've added tests 5 - 8 in blue as I think these can be compressed into 1 formula instead of 4.

Tests 5-8 basically looks for the next highest product type, and identifies what % the value of the current type is of the next highest type, this should always be lower - so if it is higher it is marked as N in test 8 and fails, feel like there must be an easier / more compressed way to do this validation test.