View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff
 
Posts: n/a
Default How do I create a payment tracking spreadsheet?

Our office went in on purchasing 5 gallon water bottles and I would like to
create a spreadsheet (or better yet find one that already does what I need, I
hate re-creating the wheel) that I can track everyone that is participating,
how much they have paid, how much they owe, based on the number of bottles we
buy, how much each will owe dividing the amount by the number of
participants, etc. Yeah, I'm sure I can do it, I just have too much on my
plate right now. Thanks in advance if anyone has something like this or
knows of anyone that has created something like this already. Access is not
totally out of the question either. I'm pretty knowledgable in db's. And
with Access I could create an email to send out to the deadbeats that owe.