Hello all anything thank you for taking the time to help me out here.
I'm trying to help a friend setup an archive which basically filters data into other sheets.

So sheet 1 will contain all the data

Tool type Serial no. Condition bla bla bla
Working / N/G
And on sheet 2,3,4+ there will be a list of all the working or N/G tools

Cheers all again