atuljadhavne
05-28-2012, 02:23 AM
Dear expert
i have format, where in D3 having (data validation list) list, and the list is in same sheet AJ4 to AJ63,
now when i select from D3 of any one data, than based on D3 value the i am getting code for that (used vlookup from another sheet) in E3
Now i want command like Next and Prev Button, so when i click on Next button the the value automatic change and pick next value, and if i press prev button than take prev value
e.g
this is sample data validation list
now when i select from drop down popup menu "Aditya" from D3, so E3 (vlookup from another sheet) has been change and based on E3 the entire format figure get changed, now when i press next button the D3 value has been changed to "Agro", next "Anmol", Prev "Agro"
ADITYA
AGRO
ANMOL
BADRINARAYAN
BHUMI
CASH
CHANDOK
any help in this regards
tnx in advance
i have format, where in D3 having (data validation list) list, and the list is in same sheet AJ4 to AJ63,
now when i select from D3 of any one data, than based on D3 value the i am getting code for that (used vlookup from another sheet) in E3
Now i want command like Next and Prev Button, so when i click on Next button the the value automatic change and pick next value, and if i press prev button than take prev value
e.g
this is sample data validation list
now when i select from drop down popup menu "Aditya" from D3, so E3 (vlookup from another sheet) has been change and based on E3 the entire format figure get changed, now when i press next button the D3 value has been changed to "Agro", next "Anmol", Prev "Agro"
ADITYA
AGRO
ANMOL
BADRINARAYAN
BHUMI
CASH
CHANDOK
any help in this regards
tnx in advance