Notifications

seamus

New Member
Joined
Oct 23, 2006
Messages
1
I would like to know how to have excel notify me when something needs ordered.

Example: I am to have 500 pallets in my warehouse, I keep an inventory where I add and subtract. When my final total gets below 500 i would like to be notified to order.

Is this possible?
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,984
Welcome to the board.

It's certainly possible.

The easiest way is probably to make a column which calculates how many are left and filter (data --> filter --> autofilter) that column for <500 (after you've applied the autofilter, click on the arrow in the cell at the top of your column, select "custom" and apply a "is less than 500" criterion) to see what items you need to reorder.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,819
Messages
5,525,080
Members
409,618
Latest member
gkllc

This Week's Hot Topics

Top