Copy cell range from one worksheet to another based on value in specific cell

[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.

 

[missinglinq]

This is pretty obviously an Excel spreadsheet you're talking about...but you've accidentally posted it under Access Modules (VBA coding.)

Access VBA <> Excel VBA

The VBA versions for both are often similar, but just as often different! You need to report it in the VBA Visual Basic for Applications section of the forum; questions on VBA for other Microsoft apps are posted/answered there.

The Missinglinq

Richmond, Virginia

The Devil's in the Details!

 

[SkipVought]

Forum707