Not sure what you are needing then...

Column a would have ticket # in row 1 and type 1 in A2, drag down to row
1008 and fill series... Column B would be Name and Column C would be
location.

"maryalkire" wrote:

trying to make a spreadsheet for a simple checklist when passing out our
fundraisers. i need the ticket # (from 1-1007) and name with who sold it and
at what location they will pick up??