Hi all,
I am trying to create an equipment tracking list. I've made up a mock form as the attachment to show you the idea of how things are sorted. The first sheet acts as the Master List and is a running log where all updates are made.
What I'm trying to do is sort "Active" and "Inactive" equipment into separate sheets without needing to manually copy information to their respective lists. Basically, I'd like to make a dynamic system such that the file will populate all the information on the next available row in these sheets.
For example, if a piece of equipment changes from "Active" to "Inactive", it will automatically add the equipment's information to the "Inactive" list and remove it from the "Active" one. Furthermore, if a piece of equipment is added to the Master List and is marked as "Active", it will add the information to the "Active" list.
The other thing I'm trying to do (kind of a stretch) is a calibration tracking list. The idea I have is that if a date is given for the calibration due date, it would recognize that as an equipment that requires calibration and would add that equipment's information to the "Calibration" sheet.
It's been a while since I've done any major Excel work, so I'm extremely rusty with using formulas. I have some experience with VBA, but I'd like to avoid it if possible due to limits on the scope of the project. From what I know using excel, this is leaning towards the VBA side. Any help or suggestions would be appreciated.
Thanks.
Bookmarks