Paramterization in Excel using VB/Macros

[arungautam005]

I have data in excel Sheet1 as below:
Pizza Type Topping Size Crust
Non-Veg Olives Large Deep_dish
Veg Cheese Large Deep_dish
Veg Olives Large Thin_Crust
Non-Veg Bacon Large Cheese
Veg Cheese Small Thin_Crust


I want to prameterize values in Sheet 2 such that

Select Pizzza Type = <<>>
and Topping = <<>>
and Size = <<>>
and Crust = <<>>

so that all the above combinations will be covered.


Please help in this regard.

 

[dguillett]

I have data in excel Sheet1 as below:
Pizza Type Topping Size Crust
Non-Veg Olives Large Deep_dish
Veg Cheese Large Deep_dish
Veg Olives Large Thin_Crust
Non-Veg Bacon Large Cheese
Veg Cheese Small Thin_Crust


I want to prameterize values in Sheet 2 such that

Select Pizzza Type = <<>>
and Topping = <<>>
and Size = <<>>
and Crust = <<>>

so that all the above combinations will be covered.


Please help in this regard.

http://www.contextures.com/xlOrderForm01.html