Greetings Excel Forum,
I'm looking to upgrade a handwritten expiration date recording system to an automated excel spreadsheet that emails me when a product is close to and/or at expiration. I've got a sheet for recording the entries and calculating the dates for manager's specials and shrinking expired products.
What I'd like to do is have an automated macro that runs every day (I assume I can set this with windows task management provided my company's macro security isn't prohibitive) to check for products that need to be put on manager's special or shrunk out. When a product does need discounting or shrinking, an email will be sent (hopefully) with all of those products on a single report instead of individual emails.
Items needing 25% off would get highlighted yellow
40% off orange
Shrink, red fill with white text
Instructions for current step would be posted in "notes" as, "Place on Manager's Special", or "Shrink".
I've tried playing around with other codes for this, but the needs of the project don't quite fit the other macros I've found so far.
I attempted to do it myself as well, but I don't really understand the initial parameters like " For Each Bcell In Sheet1.Range("K2", Sheet1.Range("K" & Rows.Count).End(xlUp))"
So I thought it'd be easier if I just started from scratch with the help of someone who knows more than me.
Thank you for your time and energy!
Bookmarks