I am needing two different things for this,
1. I am needing to be able to enter either a bid number or bid name and have it automatically fill in the other information from the bidders sheet for each live and silent auction sheets.
2. Needing all lines from silent and live auction sheets to copy and pull over to the check out sheet and sort by bidder number.
1. I am needing to be able to enter either a bid number or bid name and have it automatically fill in the other information from the bidders sheet for each live and silent auction sheets.
2. Needing all lines from silent and live auction sheets to copy and pull over to the check out sheet and sort by bidder number.
| Auction Platform 1.xlsm | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | Bid Number | Name | Phone Number | ||
| 2 | 1 | joey | (287) 201-8233 | ||
| 3 | 2 | cody | (111) 115-5533 | ||
| 4 | 3 | krys | (345) 666-9999 | ||
| 5 | 4 | sid | (199) 999-9983 | ||
| 6 | 5 | di | (209) 129-3841 | ||
| 7 | 6 | jame | (111) 111-1111 | ||
| 8 | 7 | aie | (333) 333-3333 | ||
| 9 | 8 | aaaa | (228) 486-6047 | ||
| 10 | 9 | kjsdfie | (228) 552-6058 | ||
| 11 | 10 | ksdjfi | (228) 618-6069 | ||
| 12 | 11 | lsdoi | (228) 684-6079 | ||
| 13 | 12 | ksjdfi | (228) 750-6090 | ||
| 14 | 13 | stu | (228) 816-6101 | ||
| 15 | 14 | bo | (228) 882-6111 | ||
| 16 | 15 | toe | (228) 948-6122 | ||
| 17 | 16 | moe wkj | (229) 014-6132 | ||
| 18 | 17 | eeed | (229) 080-6143 | ||
| 19 | 18 | asd | (229) 146-6154 | ||
| 20 | 19 | sdkji | (229) 212-6164 | ||
| 21 | 20 | kjsdi | (229) 278-6175 | ||
Bidders | |||||
| Auction Platform 1.xlsm | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | Item # | Item Description | Bidder # | Buyer | Winning Bid | ||
| 2 | 2 | necklace | 9 | ||||
| 3 | 5 | chair | 8 | ||||
| 4 | 6 | frame | 4 | ||||
| 5 | 7 | board | 6 | ||||
| 6 | 12 | pink frame | 14 | ||||
| 7 | 13 | dresser | 1 | ||||
| 8 | 14 | elk horn | 5 | ||||
| 9 | 15 | deer mount | 7 | ||||
| 10 | 17 | buffalo hide | 8 | ||||
| 11 | 19 | buffalo hunt | 15 | ||||
| 12 | 21 | sign | 13 | ||||
Live | |||||||
| Auction Platform 1.xlsm | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | Item # | Item Description | Bidder # | Buyer | Winning Bid | ||
| 2 | 1 | earrings | 1 | ||||
| 3 | 3 | cowboy art | 4 | ||||
| 4 | 4 | car | 6 | ||||
| 5 | 8 | t-shirt | 8 | ||||
| 6 | 9 | tanktop | 4 | ||||
| 7 | 10 | shoes | 11 | ||||
| 8 | 11 | blue board | 5 | ||||
| 9 | 16 | rug | 7 | ||||
| 10 | 18 | elk hunt | 20 | ||||
| 11 | 20 | phone | 18 | ||||
| 12 | 42 | lamp | 4 | ||||
Silent | |||||||
| Auction Platform 1.xlsm | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | Item # | Item Description | Buyer | Bidder # | Winning Bid | Amount PAID | payment type | ||
| 2 | 1 | earrings | 1 | ||||||
| 3 | 3 | cowboy art | 4 | ||||||
| 4 | 4 | car | 6 | ||||||
| 5 | 8 | t-shirt | 8 | ||||||
| 6 | 9 | tanktop | 4 | ||||||
| 7 | 10 | shoes | 11 | ||||||
| 8 | 11 | blue board | 5 | ||||||
| 9 | 16 | rug | 7 | ||||||
| 10 | 18 | elk hunt | 20 | ||||||
| 11 | 20 | phone | 18 | ||||||
| 12 | 42 | lamp | 4 | ||||||
| 13 | 2 | necklace | 9 | ||||||
| 14 | 5 | chair | 8 | ||||||
| 15 | 6 | frame | 4 | ||||||
| 16 | 7 | board | 6 | ||||||
| 17 | 12 | pink frame | 14 | ||||||
| 18 | 13 | dresser | 1 | ||||||
| 19 | 14 | elk horn | 5 | ||||||
| 20 | 15 | deer mount | 7 | ||||||
| 21 | 17 | buffalo hide | 8 | ||||||
| 22 | 19 | buffalo hunt | 15 | ||||||
| 23 | 21 | sign | 13 | ||||||
Check out | |||||||||
| Cells with Data Validation | ||
|---|---|---|
| Cell | Allow | Criteria |
| G1 | List | =$L$3:$L$5 |
