EXCEL question - advance warning /tracking

Hi

I'm trying to program Excel to track customer payments and warn me when a certain bill is becoming due.

For example if i have two columns - 1-30 and 30-60 how can i program Excel to warn me when the due payment is nearing the 3-60 column?

Thanks in advance

 

I am checking into this, though I have never used anything like this in Excel and am not sure if you can do it. I will reply back if I figure out how to do it. Good luck.

 

I did not try it but this might work for you:

Subscribe to be notified of changes to a file or discussion

You can subscribe to receive notification of any type of change made in a file, discussion, or even a folder.

1. In Microsoft Internet Explorer, on the Standard Buttons toolbar, click Discuss http://forums.majorgeeks.com/mk:@MSITStore:C:\Program%20Files\Microsoft%20Office\Office10\1033\ofmain10.chm::/images/distlbr.gif.
2. If you are prompted to select a discussion server, do so. http://forums.majorgeeks.com/mk:@MSITStore:C:\Program%20Files\Microsoft%20Office\Office10\1033\ofmain10.chm::/images/blueup.gifHow?
   1. In the Type the name of the discussion server your administrator has provided box, type the name of a discussion server.
   2. If your system administrator has set up security by using the Secure Sockets Layer (SSL) message protocol, select the Secure connection required (SSL) check box.
   3. In the You can type any name you want to use as a friendly name for the discussion server box, type a friendly name you want to use for the server; for example, My Server.
   <LI class=LPROC>On the Web Discussions toolbar, click Subscribe. <LI class=LPROC>Choose whether to subscribe to the current page, or to a Web folder. Do one of the following under Subscribe to:
   • To subscribe to the current page, select File.
   • To subscribe to all files in a Web folder, select Folder, and then select the options you want, or type the address of another folder.
   Note You can subscribe to another page or file by typing its URL in the File or Folder box.
3. In the When box, select the conditions under which you want to be notified of changes made.
4. In the Address box, type your e-mail address.
5. In the Time box, select how often you want to be notified of changes

I hope this proves to be helpful, I will keep looking.

 

Nevermind, that is not what you are looking for. Still looking.

 

Thanks comp - I really appreciate it.

 

I cannot seem to find a way to do this and I have been playing with Excel to determine a way. Hopefully, assuming there is a way to do it, someone will come along and have an answer for you. Sorry for not being able to be more helpful.

 

Thanks for trying. i really appreciate you spending your time on this. Thanks again.

 

btw - you wouldnt happen to know of a program that does this would you (non EXCEL)

 

Check out the Date and Solver functions. They might point you in the right direction.

Solver is an add-in function (in Office 2000, at least). Bazza

===

 

Do you have Microsoft Access? IMO, it would work better than Excel for this type of application.

 

Much tougher to learn though, IMO (for me anyhow ). Bazza

===

 

I have Access but I 've never used it. I'd have to learn how to though.