Most valuable professional
  • Hot Topics

Excel Auto Insert Data Validation Based On Cell Data

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.

This question generated 22 answers. To proceed to the answers, click here.

This thread is current as of December 31, 2013.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel