I would like help with creating a simple database in Excel.
This is for a non-profit silent auction.
I need two different tables/charts that have the following information:
#1 "Items" - Item #, Item Name, Winning Bid Amount, Winning Bidder Name, Winning Bidder Telephone Number, Winning Bidder Email Address
#2 "Winning Bidders" - Winning Bidder Name, Winning Bidder, Winning Bidder Telephone Number, Winning Bidder Email Address, Winning Bidder Total Amount Won
For easy checkout at the end of the night, I would like for the #2 table/chart to be a quick synopsis of how much each person will owe.
Is this a possibility in Excel? Relationships between Winning Bidder Name in table/chart #1 and #2?
Any help will be greatly appreciated!