PDA

View Full Version : Data Validation List



atuljadhavne
06-01-2012, 10:04 PM
Dear Expert

I have below list in Data validation list
now i don't want all the list on every time, the list in divided in segment like A, B,C,D
is it possible if i select A, then bases on A the validation list show only A segment list (First four name), than if i change A to B than the validation list change to 5 yo 8

in short:- validation list based on other validation list
First validation list having "A, B, C, D"
second validation list is Name (mentioned below)

using excel 2007

A PORWAL MOTORS
A Pawan Electicals
A M/S CHANDOK MACHINERIES
A M/S.Shubh Labh Water Technology
B Sabir & Sons
B Sabir Trading Corporation
B Sanghvi Traders
B Shree Ganesh Agro
C Kissan Tractors
C Krishi Paramarsh Kendra
C Shubh Labh Agri Business Centre
C Mohan Agrocrats
D Sumitra Agrotech
D JAIN SALES CORPORATION
D M/S Sanjay Sales Corporation

Aussiebear
06-01-2012, 11:36 PM
Debra Dalgliesh has an excellent website for this. Please have a look at http://www.contextures.com/xlDataVal02.html