Good morning,
I have tried using existing information on this website but still don’t understand enough about VBA to adapt it for my own use.
I have a certificate database. Each certificate has a validity date. When this date passes the equipment has to be retested and a new certificate added to the database.
Certificate dates are already conditional formatted as follows
Red - out of date
Orange - <= 10 days remaining
Green - > 10 days remaining
I would like to automatically copy the row from the main database to a new worksheet based on whether the certificate is green, orange, red flagged, leaving the main database intact.
When each certificate reaches its next change of state, eg green to orange, or orange to red, it should move down the ladder to the next worksheet, leaving only greens in the green worksheet, oranges in the orange worksheet, etc.
In addition to this, when the row is moved it must be inserted into the correct section number.
I also have hyperlinks to the actual certificates that need to stay active after the row has moved under column reports.
I have already created the green, orange, and red worksheets and added the section headings.
Some certificates don’t have dates, they can stay in the main database.
I know how to insert modules, just not how to write code.
If you can help it would be really appreciated.
Calmlaunch
Bookmarks