ExcelBanter - Paramterization in Excel using VB/Macros

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Paramterization in Excel using VB/Macros (https://www.excelbanter.com/excel-programming/450638-paramterization-excel-using-vbulletin-macros.html)

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.

Paramterization in Excel using VB/Macros

On Thursday, February 5, 2015 at 5:16:26 AM UTC-6, Arun Gautam wrote:
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