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!!!

Try this in the "ThisWorkbook" code module
Not knowing what cell the computer name is in I could not add that code.


Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

If Target = "None" Then
ActiveCell.Insert xlDown
'insert new row below

'copy machine above

End If
End Sub


"dcolestock" wrote:

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!!!