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