Curious as to whether or not you can create a conditional drop down menu...
EXAMPLE:
If Cell A4 is "Sun" then Cell B4 shows a drop down menu specific to that manufacturer,
If Cell A4 is "IBM" then Cell B4 shows a drop down menu specific to IBM
and so on. (Oh and I'm forced to try doing this in Excel 2003)
I may be asking too much of Excel and most likely would be better served doing what I'm attempting through Access or some other database, but I've never understood Dbases.
EXAMPLE:
If Cell A4 is "Sun" then Cell B4 shows a drop down menu specific to that manufacturer,
If Cell A4 is "IBM" then Cell B4 shows a drop down menu specific to IBM
and so on. (Oh and I'm forced to try doing this in Excel 2003)
I may be asking too much of Excel and most likely would be better served doing what I'm attempting through Access or some other database, but I've never understood Dbases.