VBA to Search and List Results Based on specified Criteria

[Bigred251]

Hello - I have a workbook (attached) with a sheet for entry, a sheet to hold data, and a sheet for results.

on the first (Entry Form) sheet, a user would enter a material # and then assign a quantity to a set of stores based on criteria

ex. entry on Sheet1 (Entry Form)


Material All Trait 1 Trait 2 Trait 3 Trait 4
5959 10
14506 20


Based on these entries, the VBA code would perform a search on the 2nd (Store List by Trait) sheet and grab all customers for material 5959, and all customers with an "x" in the Trait 2 column for material 14506.

ex. Store list on Sheet 2 (Store List by Trait)

Cust # Trait 1 Trait 2 Trait 3 Trait 4
13463 x x
13280 x x x
27777 x x
13464 x
13477 x


Those stores would then be listed in Sheet 3 (Store Level orders for Upload) along with the material # and the quantity


ex. Store level Orders on Sheet 3 (Store Level orders for Upload)

Customer Material Qty
13463 5959 10
13280 5959 10
27777 5959 10
13464 5959 10
13477 5959 10
13463 14506 20
13280 14506 20

Attached is a more detailed example. Any help is GREATLY appreciated!!

[Bigred251]

My apologies for the spacing - I am having some formatting trouble. Hopefully the attachment paints a clearer picture than the examples as shown