expiration date warning

  1. J

    GENERATE EMAIL BASED ON EXPIRATION DATE W/ DETAILS ON EMAIL BODY

    Hello, I found a code in MREXCEL that works very well but I need to tweak it a bit but I am not able to do so. This code generates an email based on 2 different types of text in column L: "Expiring Soon" and "Expired". 1) This code inserts the text in Column A and puts it in the email body...
  2. D

    Ideas on how to track inventory expiration dates

    NOTE* Please skip until the next line highlighted in bold if you're not interested in seeing how my setup functions. Thank you! Hello everybody, I am currently managing a minor inventory consisting of 101 unique goods. Currently my excel sheet looks like this: To briefly explain the sheet...
  3. L

    How do I color format dates in one column into another column

    Hi, New to the forum I'm here cos i'm stuck with a task. I have a spreadsheet with a list of dates and non dates in column A In column B I want to color highlight cells (so that they can be overwritten with other text) I want to show in column B 1) dates from column A that are greater...
  4. W

    VBA popup box warning of expiration date

    Hello guru's! I'm trying to get a popup window to show when a date is entered that is less than 8 months from today's date. I also need it to send out the alert when the spreadsheet is opened. Basically, Column A is the part number, Column B is the lot number and Column C is the expiration...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top