+ Reply to Thread
Results 1 to 2 of 2

Lottery Payment Tracker

  1. #1
    Registered User
    Join Date
    02-14-2013
    Location
    Ottawa
    MS-Off Ver
    Excel 2010
    Posts
    27

    Lottery Payment Tracker

    Hi Excel gurus,
    I'm having a lot of trouble wrapping my head around how to set up this spreadsheet. I want to track group lottery payments. I have 16 people in my pool - when someone pays me, they usually pay for at least a month in advance. I want to be able to add their payments as they come in and have the new balance reflected (this I can do) but then I want to be able to include all 16 ppl in the pool and have the lotto purchase deduct the money from their balance. I want to be able to run a pivot chart or see in one shot how much everyone's balance is as I include these details in the email I send. Here's what's making this less complicated - all 16 people are in every single draw, regardless of balance. I spot them and they pay me back. And lotto always costs the same - $5/week. This seems easy in theory but I can't figure it out. Can anyone help?
    Thanks!

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365
    Posts
    2,708

    Re: Lottery Payment Tracker

    Hi,
    Dont you even have a mock up?
    Look at the yellow banner at the top of the page and upload a sample file.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 02-14-2021, 12:49 PM
  2. Payment tracker
    By Rushendra in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-27-2020, 12:08 PM
  3. [SOLVED] 3 lottery to find out how long it has been since a lottery number hit
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-14-2020, 04:38 AM
  4. Lotto syndicate payment tracker
    By tammy.adams in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-07-2016, 05:36 AM
  5. Help build a Leave tracker and Effort Time Estimation Tracker
    By cherias in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2015, 02:10 PM
  6. Replies: 3
    Last Post: 07-29-2013, 11:31 AM
  7. Scheduled Payment Tracker..!!
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2011, 03:48 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1