In a Sheet, A1 has some dropdown menu (data validation). B1 Should act according to the selection in A1, ie., B1 should act like A1's submenu. (B1 should derive the result list from some reference cells)
Attachment query.xls enclosed as sample.
Ask me how to hate XL.
Look here please:
http://www.contextures.com/xlDataVal02.html
"Relax. What is mind? No matter. What is matter? Never mind!"
Great, Thanks zbor.
Ask me how to hate XL.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks