Further to this, I think what might be easier (for me, at least) is to automate having my Mac open the spreadsheets at a given time, so I can remember to review them and check whether anything has expired.
That part is relatively straightforward, though it does involve Calendar, Automator, Shortcuts, and whatever app the spreadsheets are in. But once it’s set I can forget about it.
@DJDarren that sounds like something you'd need to use VBA to do; but it also sounds like something that isn't a good fit for using Excel at all. whats your end goal?
We have a number of equipment registers that are Excel sheets. There’s conditional formatting for when when inspection dates come up (for example), so it would be useful to receive a message rather than having to remember to look, or manually input them all into a calendar.
@DJDarren yeah. VbA is the only way, and only if the sheet is open (or you have a seperate Loop Through All Sheets, check status, email, set sent flag sheet), in which case just use the hyperlink() function to use mailto: and send an email
@DJDarren pretty much. I mean, once it's in place it's a time saver, but you'll have to learn VBA (in reality google 'how to loop through files and send email vba excel'), test it, and maintain it...
Add comment