View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] arungautam005@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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.