Book1.xlsx
In the attachment you will see I have two tabes called License-Equanet and License-Dell, on each row i show an expiry date.
The first sheet is called 'Due to Expire'. One month before an expiry date is reached in the licenses tab I need the information in that row to appear in the 'due to expire' tab. This will then alert me one month prior to the license expiring.
Would anyone be able to assit with the code I need to put in in order to make this happen?
Hello shabbaranks32,
Welcome to the Forum.
It is always far better to use built-in Excel Features, rather than applying VBA. Why crate a Tab 'Due to Expire' and create extra work?, while one could use Conditional Formatting to highlight 'Due Dates', as I have done for you in the attached sample Workbook.
For your consideration.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks