Home

Create Database in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-310442%22%20slang%3D%22en-US%22%3ECreate%20Database%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-310442%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20help%20with%20creating%20a%20simple%20database%20in%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20for%20a%20non-profit%20silent%20auction.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20two%20different%20tables%2Fcharts%20that%20have%20the%20following%20information%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%231%20%22Items%22%20-%20Item%20%23%2C%20Item%20Name%2C%20Winning%20Bid%20Amount%2C%20Winning%20Bidder%20Name%2C%20Winning%20Bidder%20Telephone%20Number%2C%20Winning%20Bidder%20Email%20Address%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%232%20%22Winning%20Bidders%22%20-%20Winning%20Bidder%20Name%2C%20Winning%20Bidder%2C%20Winning%20Bidder%20Telephone%20Number%2C%20Winning%20Bidder%20Email%20Address%2C%20Winning%20Bidder%20Total%20Amount%20Won%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20easy%20checkout%20at%20the%20end%20of%20the%20night%2C%20I%20would%20like%20for%20the%20%232%20table%2Fchart%20to%20be%20a%20quick%20synopsis%20of%20how%20much%20each%20person%20will%20owe.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20a%20possibility%20in%20Excel%3F%20Relationships%20between%20Winning%20Bidder%20Name%20in%20table%2Fchart%20%231%20and%20%232%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20will%20be%20greatly%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-310442%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
cbm2018
Occasional Visitor

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!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies