Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop-down menus to store different data
Hi, I was wondering if it was possible to use a drop down menu to store different data for each item in the drop down list. For example if I had a drop down list with options CATS, DOGS. For both of the two I want to have exactly the same column header names (eg. No. of Pets, No. of Blue eyes etc). I want to be able to choose dogs and update all DOGS fields and vice versa (all storing just numbers). Then I should be able to extract the information needed for CATS and DOGS later as needed. This should allow lot of information to be stored in a worksheet. Thanks if anyone can help me out with this. -- workerboy ------------------------------------------------------------------------ workerboy's Profile: http://www.excelforum.com/member.php...o&userid=34121 View this thread: http://www.excelforum.com/showthread...hreadid=538922 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down menus | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Update Excel Data List for Drop Down use | Excel Discussion (Misc queries) |