Greetings! I have a different one for you, but it seems the questions I ask on this forum are always different!
Our group is holding a fundraiser. For the different amounts sent in, there are "chances to win" one of ten cash prizes.
Amount.....Chances
$25...........1
$50...........2
$100.........5
$200........10
$300........15
$500........25
$750........40
$1000......55
We are creating a file of donors, and I would like to make a separate sheet on our document that would populate the donors name a set number of times, depending on the amount. Example: Jim donated $100, and his name will be listed five times.
Example 2: Phylis and Jim donated $1000 and the name will be listed 55 times. (see sheet 2 on the attached file for examples)
My end goal will be to cut these names apart for our drawing, but it's becoming tedious and we're only at the beginning of our donor list!
I don't care which direction or anything like that; I was just hoping this was up someone's alley!
Thanks for considering this problem. (And what an awesome problem, that we have folks willing to donate during this time! I do NOT want to complain over a computer task!) I'm also open to any suggestions/alternatives to this issue!
Bookmarks