I am working with an excel spreadsheet to track all of our software, license keys, & where that software is currently installed. My workbook uses two sheets to do this, the first worksheet is named “Installed software” and the second one is called “Software”
Software Sheet:
I use this sheet to enter the software Name, Description, Version, Developer, Category, Date of Purchase, Supplier, Supplier Website, Price, License Type, Expiation /Renewal Date, Serial Number, & Quantity Purchased. I also have two fields that are calculation fields. These fields are Quantity Used & Quantity Remaining
Installed Software Sheet:
I use this sheet to enter the Name of User, a Description of Hardware, Asset Number, Date of Software Install, & Select Name of Software. Now this last field “Column G” I use a drop down field that looks at the “Software Sheet” that list all of software we have. Once I have chosen the software I am going to install from the list it changes the Calculation Field on the “Software Sheet”. i.e Quantity Used =1 & Quantity Remaining=0
What I am trying to do is automatically hide that that row on the “Software Sheet” when Quantity Remaining=0 as well as automatically update the dropdown field in Column G on the “Installed Software” Sheet so that it won’t show that software as available for install. I have been attempting to approach it from the Installed Software Sheet to hide the row on the “Software’ sheet when I select the software from the drop down list in Column G but I have not been able to get this to work
I have uploaded the sample worksheet
Bookmarks