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