hmmm,been extremely long while since i build excel DB's, you sure you need excel for this ? as access can do this for you and easier.
for the drop down you can use "look-up" or a "combo box", so that when ITEM1 is selected, only details on ITEM1 will be shown !!
__________________
Laptop: Thinkpad X60: Core2Duo T7200 @ 2Ghz,1GB DDR2,120GB SATA -winXP ProSP3
Work:CoreDuo E2180 @ 2Ghz,1.5GB DDR2,240GB Sata II HD - XP PRO SP3
Broken: Dell Optiplex 210L @ 2.8ghz P4HT,512MB DDR2 533, 80GB HD- OSX 10.5.2
|