Send and Search button's

Hi

I am pretty new at this, so i have tried to modify code i have found online, and it works ok.
But i would like to make it a bit more advanced.
I want the data in the summary sheet to be moved to specific sheets based on the row cell, so if the value in the row cell is 1 its send to the row1 sheet and so on, and at the same time if the value in the Pre,cam,scan,An cells is set to ok, the data is to be copied to the Pre,Cam,Scan,An shetts.

I also want the search button to be able to fetch data from the different sheets based on the item number entered, and when fetched i want to be able to change the value in the Row,Pre,Cam,Scan,An cells press send and the item is send to the new sheets, and cleared from the old sheets.

Also when you press send the cells in the summary sheet should be cleared.

Thanks in advance

This should take you to the correct worksheet.

Please Login or Register  to view this content.

Your example does not have the other sheets you mention

Oups, sorry it does now

I have added a couple of other small changes. Timestamp and user info.

and thanks for the help, works like a charm.