Paramterization in Excel using VB/Macros
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.
|