Copy from one sheet to another sheet depend on cell value

[KlausW]

Hi all Excel helpers.
I have a challenge.
In a sheet, I test whether my employees have received the uniform parts they need, if I put a number next to the uniform parts in question and the employee in question, they have not received what they need.
In column B, the uniform parts are cell B2 to cell B122. In rows C1 to V1, employee no.
Now it's like that I would like to have moved employee number and the uniform parts with number over to a new sheet. It has to be formal.
All help will be appreciated
With best regards
Klaus W

 

[Saurabhj]

Great. Thanks for feedback, Klaus.

 

[KlausW]

Good morning Saurabh, what you have made work flawlessly. I have a question. Can change the way in which on Excel inserts data in sheets TOJ MISSING? Many greetings Klaus