Dynamic List Based on Drop Down Data Validation

tahas

New member
Joined
Sep 25, 2012
Messages
4
Reaction score
0
Points
0
Location
Richmond Hill, ON Canada
Excel Version(s)
2010, 365
Hello folks,

Our procurement process requires certain documents to be completed and submitted based on the dollar value. I have created a drop down field using data validation i.e. Up to $5000
$5001 to $10000, $10001 to $25000, $25001 to $50000, $50001 to $100000

What I am trying to accomplish:

In CELL A1 user selects a dollar value say Up to $5000

CELL A3 to A8 show following list (I don’t what this to be in another drop down data validation)

References Check Form
Formal Quote
Purchasing Requisition
Certificate of Insurance Form
WSIB Certificate of Clearance
Purchase Order (PO)
Signature – Branch Manager

Similarly for $5001 to $10000 following list should appear in CELL A3 to A11

Request for Quotation
References Check Form
Formal Quote
Quotation Summary Form
Purchasing Requisition
Certificate of Insurance Form
WSIB Certificate of Clearance
Purchase Order (PO)
Signature - Branch Head (Managing Director / General Manager)

Thanks in advance for any help.
TH​
 
Back
Top