Create macro that sends out emails when quantity is less than or equal to minimum stock

David77

Board Regular
Joined
Jun 24, 2020
Messages
85
Office Version
365
Platform
Windows
Hello everybody,

My current excel-file looks like this:

1593693884485.png


I would like to create a macro that, once I click on it, checks if the quantity is less than or equal to the minimum stock. So in the photo, for row 2 where material number "6046100" has a minimum stock of "1" and the quantity on the same row is inserted as value = 0 I would like to have a command button macro where, once I click on it, it checks every single column in the minimum stock row to see if the value is higher than the quantity (or opposite = check quantity column to see if it is lower than the respective minimum stock value).

Can anybody help me create such an alert please? I would truly appreciate it! Thank you very much for your time everybody :)

Best regards,
David
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,959
Messages
5,508,409
Members
408,682
Latest member
alifarhat

This Week's Hot Topics

Top