hey all i have problem regarding data validation(list).
if i have sheet1 that contain :
A |B |
code |item |
1384 |glue |
2940 |box |
and i have sheet2 that contain :
A |B |
code |item |
if then i want to use dropdown menu..that refer to sheet1 and when i choose dropdown menu for item 1384 in column A sheet2 can it show the item as well in column B sheet2.thanks in advanced
Hi mtsf26
I am new to posting onto forums so if I have got this wrong sorry.
I once had a similar problem and the following website helped me.
contextures.com/Excel-VBA-ComboBox-Lists.html
Use VLOOKUP
=VLOOKUP(A2,Sheet1!A:B,2,False)
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
To use a list for validation from another sheet you would have to make it a named range
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
@uqh65q hey thanks its so useful for me..i will try it too...
@xld thanks it also the solution..
@simon lloyd i also have named the range.
Posting Permissions
Reply With Quote
