Morning all
I'm trying to create a worksheet for a friend where he can open it, click on sheet 'ok for use' and have all the tools listed there.

I've tried showing how to use the auto filter but I'm really not getting anywhere with it.
So I decided to try and have Sheet 1 to list everything:

Tool type Ser. Number line (1/2) condition ect



There all the data would be put in.

On sheet 2, it would list all the Good conditioned tools or which ever ones I want on sheet 2.

I understand some basics but what I can't seem to get the sheet to do is index all the data on sheet 1 and then copy a whole line to sheet 2/3/4ect depending on the value of a field in the list.


All help is grateful and appreciated.

Thank you all!