mtsf26
01-14-2012, 01:56 AM
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
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