Hi,
I have create a Order Form and need some help. this order form is for customer to choose the items that they are going to buy. and for certain items we giving them 1 or 2 free gift but not for all.
MySheets1 ("A19") is for choosing the products "Data Validation List"
What i want is that, base on difference products that the customer select in ("A19") i want Cell A25 or A25 & A26 to add data validation list from Sheets2
if Sheets1 ("A19") select = "Products 1" then Sheets1 ("A25") automatically add data validation list from sheets2 A1:A20
if Sheets1 ("A19") select = "Products 2" then Sheets1 ("A25") & ("A26") automatically add data validation list from sheets2 B1:B20 & C1:C20
if Sheets1 ("A19") select = "Products 3" then Sheets1 ("A25") No data validation added
if Sheets1 ("A19") select = "" then Sheets1 ("A25") No data validation added
Any Help Will Be Appreciate.
I have create a Order Form and need some help. this order form is for customer to choose the items that they are going to buy. and for certain items we giving them 1 or 2 free gift but not for all.
MySheets1 ("A19") is for choosing the products "Data Validation List"
What i want is that, base on difference products that the customer select in ("A19") i want Cell A25 or A25 & A26 to add data validation list from Sheets2
if Sheets1 ("A19") select = "Products 1" then Sheets1 ("A25") automatically add data validation list from sheets2 A1:A20
if Sheets1 ("A19") select = "Products 2" then Sheets1 ("A25") & ("A26") automatically add data validation list from sheets2 B1:B20 & C1:C20
if Sheets1 ("A19") select = "Products 3" then Sheets1 ("A25") No data validation added
if Sheets1 ("A19") select = "" then Sheets1 ("A25") No data validation added
Any Help Will Be Appreciate.