Fundraiser -Tracking Students progress

Originally Posted by tmac

I need to create a spreadsheet for a school fundraiser. All students are selling 5 "discount cards" each and they are numbered in sequence. Some students will sell more than their 5 cards. I would like to be able to enter their name, address, Card # (ex: 00101-00105), Another column in case they sell additional cards, sales, & cards returned. Instead of me having to enter each card # I would hope I could use a formular so I would only have to enter 1 number for each student and the formular would add 4 more to it for a complete # sequence (ex. 00101 - 00105). I hope this makes sense. I would appreciate all help.

Basically, I need to track all card numbers and know the cards are turned back in or the money for cards sold.

Thanks very much.

Hi,

With the start number in A1, in A2 put

=OFFSET(A2,-1,1)+1

in b1 put

=A1+(IF(C1<>"",C1-1,0))

in C column enter the number of tickets if not = 1

select column B, format, Conditional, Formula, =B1=A1 and set the font to White (on white)

formula fill B1 and A2 down as far as your student numbers

Let me know how you go
---

Originally Posted by tmac

Sorry Bryan, I'm not following. This is what my columns look at this point.

Start # End# Addtnl Cards Sold Profit Cards Returned Name
00001 00005

I know I'm not being clear on this because I can't get it in my mind how to best keep track of the cards. Each student received 5 cards total to sell and many will get additional cards. I want to be able to track the cards & make sure they return the cards or money and also keep up with the profit. Thank you very much for your time and advice.

Hi,

did you apply the settings as shown?

if so, then you enter only the very first Start number, and then the number of cards per student if not = 1 (you can enter 1, but it defaults to that) (ok, to default to 5 adjust as per the attached)

the Sold will be end - start - returned
the profit ?
the returned will be entered by you, 0 to indicate all sold (blank is 'pending')
name is entered by you

name is the initial entry, it triggers a default 5 tickets
enter ticket numbers if not 5
enter 0 returned for 'sold all'

Profit?

hth
---