cillyRabbit
New Member
- Joined
- May 19, 2021
- Messages
- 7
- Office Version
- 2019
- Platform
- Windows
Hello everyone,
Programming was a trait I stopped polishing 10+ years ago. VBA is entirely new to me.
We needed to put together a CMMS system and I couldn't find one out there that I really liked so I set out to build my own. I do enjoy the struggles but I have reached the point where I need some help.
CMMS is just tracking maintenance. So I have a table that has the following columns (MaintenanceID, Date, AssetID, AssetName, AssetHours (Heavy equipment), Maintenance Type, etc.)
I am able to use Application.WorksheetFunction.MaxIfs to determine the date that the last maintenance that was done for an asset.
I am able to generate the assetID.
However with the assetID and the last date of service held in separate variables, I can not for the life of me figure out how to pull the "AssetHours" from the last service.
I have tried Index..Match but I am at a loss and keep running in syntax circles.
Would anyone be interested in looking at the project?
Thank you,
-Kevin
What I have so far is pretty neat, at a glance our mechanic will be able to see in a color coded fashion what assets need service, and how much life (as a percentage) is left before they need service.
Programming was a trait I stopped polishing 10+ years ago. VBA is entirely new to me.
We needed to put together a CMMS system and I couldn't find one out there that I really liked so I set out to build my own. I do enjoy the struggles but I have reached the point where I need some help.
CMMS is just tracking maintenance. So I have a table that has the following columns (MaintenanceID, Date, AssetID, AssetName, AssetHours (Heavy equipment), Maintenance Type, etc.)
I am able to use Application.WorksheetFunction.MaxIfs to determine the date that the last maintenance that was done for an asset.
I am able to generate the assetID.
However with the assetID and the last date of service held in separate variables, I can not for the life of me figure out how to pull the "AssetHours" from the last service.
I have tried Index..Match but I am at a loss and keep running in syntax circles.
Would anyone be interested in looking at the project?
Thank you,
-Kevin
What I have so far is pretty neat, at a glance our mechanic will be able to see in a color coded fashion what assets need service, and how much life (as a percentage) is left before they need service.