I am trying to create a database in excel that inventories the software that
our firm owns. The workbook shows a computer name, user, and then several
software categories each associated with a list. (example: under 'Autodesk
Product', options would be 'none', 'Map 2008', 'Civil 3D 2008', etc...)
However, I would like to program the spreadsheet so that if anything but the
'none' option is selected, a second row is automatically created and attached
to the same computer, so that it is possible to associate more than one
product in a given category with that computer. Is this possible? Hopefully
the description makes sense, I am a novice excel user and am trying to ensure
this spreadsheet is as user-friendly as possible for future use. Please
help!!!