IF Function to create message or alert

Hi all,

I am creating an IF function for a ticketing company. I'm trying to setup a system whereby when the number of tickets in a cell reads something other than zero, within 24 hours of the date in another cell, it creates a message either within Excel itself, or can possibly send an email via Outlook. This could also be used to control stock i.e. when stock levels reach a low limit, it triggers an email to be sent or an error message to be displayed.

Am I asking the impossible? Any help is greatly appreciated.

Regards,

Jon

Hi,

Say you have a spreadsheet col A contains the dates of shows, col B contains the number of tickets.

A B
Dates Tickets Left
17/04/2007 50
18/04/2007 70
19/04/2007 100
20/04/2007 90
21/04/2007 60
22/04/2007 100
23/04/2007 100
24/04/2007 100
25/04/2007 100

Code:

Please Login or Register  to view this content.

havent tested it!

Hope it helps!
mccreaso

I need some help. Please reply if anyone is online?