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
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