Copy cells to another worksheet if value is correct

[thomasks]

I have an order worksheet that engineers choose parts from. The Vendor name is called out in cell H5.
There are other worksheets with the names of the vendors on the tabs for each sheet. I would like to program a button that would look down through the front master sheet and sort the items that the engineer selected by vendor and put them on their vendor specific sheets with VBA.
As it is now you have to manually cut and paste the items yourself.
Thanks for any help you could give me.

 

[SkipVought]

Hi,

What is the structure of your Master sheet?

Is it possible for you to post a sample of this sheet?

The VendorName is located in H5. Is ther anything else in row 5?

Is there stuff in rows 1-4?

Please answer all these questions fully.