Hello, all!
A local youth group is hosting an auction next month, and I have been tasked with creating the spreadsheet for recording winning bidders and winning bids, and making redemption vouchers to give to the winning bidders once they've paid.
Here's what the Excel document I have set up looks like:
Worksheet 1 columns: Item #(1), Item Description (2), Winning Bidder ID # (3), Winning Bid (3)
Worksheet 2 columns: Bidder ID # (1), First Name (4), Last Name (4)
(1) = Sequentially increasing from 1 to n, populated prior to event
(2) = Entered prior to event
(3) = Recorded when silent auction closes/during live auction
(4) = Recorded as people enter auction
What it sounded like they are wanting for the vouchers is just to print off a bunch, and write down on each what item numbers they won as the winning bidders check out (from there they'll take it over to another station, and use the voucher to redeem their items). What I'm planning on doing for this is setting up a mail merge in Word that pulls all the names and bidder ID #'s and automatically puts them on the vouchers.
Now, all that is simple enough to do. Here's where it starts to get complicated:
Initially I had been thinking of it populating all the fields in the "Cards.docx" file attached, and calculating the total amount owed so that the people checking out bidders can do this more quickly. However, the following would work.
In order to expedite the overall process, I'd like to make the vouchers automatically pull the list of items over from the spreedsheet.
I've got an idea of how this could work, but haven't a clue what tools to use to accomplish it:
Inside Excel, in worksheet 2, a third column would look at what the bidder ID # is, match that up with winning bidder #'s in worksheet 1, and list them all in the same cell (appearing something like "1, 52, 173"). From here it's a simple merge field added to the voucher Word document.
Any ideas what tools I could utilize? I've used Excel formulas in the past, but am unsure as to whether they have this capability. I'd imagine I will need to delve into macros, which is beyond the scope of my experience, but am more than willing to learn if pointed in the right direction.
Thanks in advance!
ElectroPulse
EDIT: Attached is an example spreadsheet, and "cards.docx" is what I had initially been picturing as what the vouchers would look like, but am thinking that would be a bit complex for this.
Bookmarks