auto fill, copying and sorting sheets using macros if possible since I am already using it.

[khelp11]

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.

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
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
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	F	G
1	Item #	Item Description	Buyer	Bidder #	Winning Bid	Amount PAID	payment type
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Check out

Cells with Data Validation
Cell	Allow	Criteria
G1:G22	List	=$L$3:$L$5

 

[Jeffrey Mahoney]

How about something like this:

Book2
	A	B	C	D	E
1	Item #	Item Description	Bidder #	Buyer	Winning Bid
2	1	earrings	1	joey	$14.00
3	3	cowboy art	4	sid	$500.00
4	4	car	6	jame	$1,501.00
5	8	t-shirt	8	aaaa	$4.00
6	9	tanktop	4	sid	$5.00
7	10	shoes	11	lsdoi	$15.00
8	11	blue board	5	di	$20.00
9	16	rug	7	aie	$100.00
10	18	elk hunt	20	kjsdi	$200.00
11	20	phone	18	asd	$50.00
12	42	lamp	4	sid	$60.00
Silent

Cell Formulas
Range	Formula
D2:D12	D2	=XLOOKUP(C2,BiddersTbl[Bid Number],BiddersTbl[Name],"Not Found",0)

Book2
	A	B	C	D	E
1	Item #	Item Description	Bidder #	Buyer	Winning Bid
2	2	necklace	9	kjsdfie
3	5	chair	8	aaaa
4	6	frame	4	sid
5	7	board	6	jame
6	12	pink frame	14	bo
7	13	dresser	1	joey
8	14	elk horn	5	di
9	15	deer mount	7	aie
10	17	buffalo hide	8	aaaa
11	19	buffalo hunt	15	toe
12	21	sign	13	stu
Live

Cell Formulas
Range	Formula
D2:D12	D2	=XLOOKUP(C2,BiddersTbl[Bid Number],BiddersTbl[Name],"Not Found",0)

Book2
	A	B	C
1	Bid Number	Name	Phone Number
2	1	joey	2872018233
3	2	cody	1111155533
4	3	krys	3456669999
5	4	sid	1999999983
6	5	di	2091293841
7	6	jame	1111111111
8	7	aie	3333333333
9	8	aaaa	2284866047
10	9	kjsdfie	2285526058
11	10	ksdjfi	2286186069
12	11	lsdoi	2286846079
13	12	ksjdfi	2287506090
14	13	stu	2288166101
15	14	bo	2288826111
16	15	toe	2289486122
17	16	moe wkj	2290146132
18	17	eeed	2290806143
19	18	asd	2291466154
20	19	sdkji	2292126164
21	20	kjsdi	2292786175
Bidders

Book2
	A	B	C	D	E	F	G
1	Item #	Item Description	Buyer	Bidder #	Winning Bid	Amount PAID	payment type
2	1	earrings	joey	1	$14.00
3	2	necklace	kjsdfie	9	$0.00
4	3	cowboy art	sid	4	$500.00
5	4	car	jame	6	$1,501.00
6	5	chair	aaaa	8	$0.00
7	6	frame	sid	4	$0.00
8	7	board	jame	6	$0.00
9	8	t-shirt	aaaa	8	$4.00
10	9	tanktop	sid	4	$5.00
11	10	shoes	lsdoi	11	$15.00
12	11	blue board	di	5	$20.00
13	12	pink frame	bo	14	$0.00
14	13	dresser	joey	1	$0.00
15	14	elk horn	di	5	$0.00
16	15	deer mount	aie	7	$0.00
17	16	rug	aie	7	$100.00
18	17	buffalo hide	aaaa	8	$0.00
19	18	elk hunt	kjsdi	20	$200.00
20	19	buffalo hunt	toe	15	$0.00
21	20	phone	asd	18	$50.00
22	21	sign	stu	13	$0.00
23	42	lamp	sid	4	$60.00
CheckOut

Cell Formulas
Range	Formula
A2:A23	A2	=SORT(VSTACK(SilentTbl[Item '#],LiveTbl[Item '#]))
B2:B23	B2	=IF(COUNTIF(SilentTbl[Item '#],CheckOut!$A2)>0,XLOOKUP(CheckOut!$A2,SilentTbl[Item '#],SilentTbl[Item Description],0,0),XLOOKUP(CheckOut!$A2,LiveTbl[Item '#],LiveTbl[Item Description],0,0))
C2:C23	C2	=IF(COUNTIF(SilentTbl[Item '#],CheckOut!$A2)>0,XLOOKUP(CheckOut!$A2,SilentTbl[Item '#],SilentTbl[Buyer],0,0),XLOOKUP(CheckOut!$A2,LiveTbl[Item '#],LiveTbl[Buyer],0,0))
D2:D23	D2	=IF(COUNTIF(SilentTbl[Item '#],CheckOut!$A2)>0,XLOOKUP(CheckOut!$A2,SilentTbl[Item '#],SilentTbl[Bidder '#],0,0),XLOOKUP(CheckOut!$A2,LiveTbl[Item '#],LiveTbl[Bidder '#],0,0))
E2:E23	E2	=IF(COUNTIF(SilentTbl[Item '#],CheckOut!$A2)>0,XLOOKUP(CheckOut!$A2,SilentTbl[Item '#],SilentTbl[Winning Bid],0,0),XLOOKUP(CheckOut!$A2,LiveTbl[Item '#],LiveTbl[Winning Bid],0,0))
Dynamic array formulas.

 

[khelp11]

How about something like this:

Book2
	A	B	C	D	E
1	Item #	Item Description	Bidder #	Buyer	Winning Bid
2	1	earrings	1	joey	$14.00
3	3	cowboy art	4	sid	$500.00
4	4	car	6	jame	$1,501.00
5	8	t-shirt	8	aaaa	$4.00
6	9	tanktop	4	sid	$5.00
7	10	shoes	11	lsdoi	$15.00
8	11	blue board	5	di	$20.00
9	16	rug	7	aie	$100.00
10	18	elk hunt	20	kjsdi	$200.00
11	20	phone	18	asd	$50.00
12	42	lamp	4	sid	$60.00
Silent

Cell Formulas
Range	Formula
D2:D12	D2	=XLOOKUP(C2,BiddersTbl[Bid Number],BiddersTbl[Name],"Not Found",0)

Book2
	A	B	C	D	E
1	Item #	Item Description	Bidder #	Buyer	Winning Bid
2	2	necklace	9	kjsdfie
3	5	chair	8	aaaa
4	6	frame	4	sid
5	7	board	6	jame
6	12	pink frame	14	bo
7	13	dresser	1	joey
8	14	elk horn	5	di
9	15	deer mount	7	aie
10	17	buffalo hide	8	aaaa
11	19	buffalo hunt	15	toe
12	21	sign	13	stu
Live

Cell Formulas
Range	Formula
D2:D12	D2	=XLOOKUP(C2,BiddersTbl[Bid Number],BiddersTbl[Name],"Not Found",0)

Book2
	A	B	C
1	Bid Number	Name	Phone Number
2	1	joey	2872018233
3	2	cody	1111155533
4	3	krys	3456669999
5	4	sid	1999999983
6	5	di	2091293841
7	6	jame	1111111111
8	7	aie	3333333333
9	8	aaaa	2284866047
10	9	kjsdfie	2285526058
11	10	ksdjfi	2286186069
12	11	lsdoi	2286846079
13	12	ksjdfi	2287506090
14	13	stu	2288166101
15	14	bo	2288826111
16	15	toe	2289486122
17	16	moe wkj	2290146132
18	17	eeed	2290806143
19	18	asd	2291466154
20	19	sdkji	2292126164
21	20	kjsdi	2292786175
Bidders

Book2
	A	B	C	D	E	F	G
1	Item #	Item Description	Buyer	Bidder #	Winning Bid	Amount PAID	payment type
2	1	earrings	joey	1	$14.00
3	2	necklace	kjsdfie	9	$0.00
4	3	cowboy art	sid	4	$500.00
5	4	car	jame	6	$1,501.00
6	5	chair	aaaa	8	$0.00
7	6	frame	sid	4	$0.00
8	7	board	jame	6	$0.00
9	8	t-shirt	aaaa	8	$4.00
10	9	tanktop	sid	4	$5.00
11	10	shoes	lsdoi	11	$15.00
12	11	blue board	di	5	$20.00
13	12	pink frame	bo	14	$0.00
14	13	dresser	joey	1	$0.00
15	14	elk horn	di	5	$0.00
16	15	deer mount	aie	7	$0.00
17	16	rug	aie	7	$100.00
18	17	buffalo hide	aaaa	8	$0.00
19	18	elk hunt	kjsdi	20	$200.00
20	19	buffalo hunt	toe	15	$0.00
21	20	phone	asd	18	$50.00
22	21	sign	stu	13	$0.00
23	42	lamp	sid	4	$60.00
CheckOut

Cell Formulas
Range	Formula
A2:A23	A2	=SORT(VSTACK(SilentTbl[Item '#],LiveTbl[Item '#]))
B2:B23	B2	=IF(COUNTIF(SilentTbl[Item '#],CheckOut!$A2)>0,XLOOKUP(CheckOut!$A2,SilentTbl[Item '#],SilentTbl[Item Description],0,0),XLOOKUP(CheckOut!$A2,LiveTbl[Item '#],LiveTbl[Item Description],0,0))
C2:C23	C2	=IF(COUNTIF(SilentTbl[Item '#],CheckOut!$A2)>0,XLOOKUP(CheckOut!$A2,SilentTbl[Item '#],SilentTbl[Buyer],0,0),XLOOKUP(CheckOut!$A2,LiveTbl[Item '#],LiveTbl[Buyer],0,0))
D2:D23	D2	=IF(COUNTIF(SilentTbl[Item '#],CheckOut!$A2)>0,XLOOKUP(CheckOut!$A2,SilentTbl[Item '#],SilentTbl[Bidder '#],0,0),XLOOKUP(CheckOut!$A2,LiveTbl[Item '#],LiveTbl[Bidder '#],0,0))
E2:E23	E2	=IF(COUNTIF(SilentTbl[Item '#],CheckOut!$A2)>0,XLOOKUP(CheckOut!$A2,SilentTbl[Item '#],SilentTbl[Winning Bid],0,0),XLOOKUP(CheckOut!$A2,LiveTbl[Item '#],LiveTbl[Winning Bid],0,0))
Dynamic array formulas.

These formulas do not work when I copy them in the fields.

 

[Jeffrey Mahoney]

Sorry, Office 2011 is not compatible