Hi All,
Need your help in solving one excel Query, don't know exactly how to solve it but might require Macros VBA coding.
Query:
I have Excel file which contain 2 sheets ("sheet 1", "sheet 2").
Sheet 1: Contain drop down list in all column A cells reference sheet 2 column A
Sheet 2: Contain more than 10000 rows of data, where Column A contain serial no. (1 to 10000) like 1, 1.1, 1.2,2,2.1....... etc.
what my query here is "When i select from drop down list on cell of sheet 1 Column A then data in that pariticular row of sheet 2 should be displayed in sheet 1 that row all columns. "
Example :
Sheet 2
S.NO. NAME NUMBER ADDRESS
1 Ankit 123 sdf
2 jain 456 sdfsd
3 Ram 789 dsfvdv
4 Prasad 123 gfhbg
5 Mohit 456 mnjhk
6 Dubey 789 uik
7 Prem 789 uik
8 Daga 4561 ryt
9 Sourabh 132456 trg
10 Dhingra 456789 vbn
Sheet 1
S.NO. NAME Address
>>> here S.NO. column contain drop down list in all cell reference Sheet2
When user select 3 in any row on serial no. column than data in sheet 2 i.e. "Ram dsfvdv " should be displayed in sheet 1 in below format
S.NO. NAME Address
3 Ram dsfvdv
please help in solving above query.
Thanks in advance.
Bookmarks