Find multiple matching cells on a row in two worksheets and add missing information using VBA

[arnejon]

I have been stuck on this issue for some days now and I have searched through several forums but no luck. I will try to explain my issue as simple way as possible.

I have a ws called “Equipment List” that is overview of an inventory. I also have several ws called “Request lists 1”, “Request lists 2” and more.
The “Equipment List” includes a serial number for each item, but the “Request Lists” has all the information except for the serial.
I have a UserForm that calls up the available worksheets (“Request Lists”) and then I can choose the suitable.
I have also managed to create a DoubleClick “check” function in Column A “Equipment List”, based on this information I would like to:

• When pressing a “Export” button I would like it to compare the information in column C,D,E and F in the “Equipment List” with the same columns in the “Request List” that I have chosen. (ListBox1.Value)
• Then based on the “Check” in column A, copy the unique “Serial” (Column B) from “Equipment List” and paste it to the matching row and column found in in the “Request List”.
• Then bring the “Location” from the “Request list” (H1) to the location column in “Equipment List”

I have started working on the macro but have been unable to come up with anything useful.

Please understand my skills within VBA Is limited, but I am interested to learn more and i am very grateful if anyone could help me.

Find and match.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1		Serial	Item nr	Criteria	Spec 1	Spec 2	Location
2	✓	1214	Item 1	Criteria 9	22 1/2	22 1/2
3	✓	1216	Item 1	Criteria 9	22 1/2	22 1/2
4	✓	1424	Item 1	Criteria 9	22 1/2	22 1/2
5		5148	Item 1	Criteria 9	22 1/2	22 1/2
6		7854	Item 1	Criteria 7	22 1/2	22 1/2
7		7474	Item 1	Criteria 7	22 1/2	22 1/2
8		5858	Item 1	Criteria 7	22 1/2	22 1/2
9		6969	Item 1	Criteria 7	20 1/8	12 1/4
10		5647	Item 2	Criteria 7	20 1/8	12 1/4
11		1574	Item 2	Criteria 7	20 1/8	12 1/4
12		1547	Item 2	Criteria 7	20 1/8	12 1/2
13		2521	Item 2	Criteria 2	20 1/8	12 1/2
14		3252	Item 2	Criteria 2	22 1/2	22 1/2
15		6352	Item 2	Criteria 2	22 1/2	22 1/2
16		1582	Item 2	Criteria 2	22 1/2	22 1/2
17		8542	Item 2	Criteria 2	20 1/8	12 1/4
18		6957	Item 2	Criteria 2	20 1/8	12 1/2
19		4758	Item 3	Criteria 2	22 1/2	22 1/2
20		9685	Item 3	Criteria 2	20 1/8	12 1/4
21		5852	Item 3	Criteria 2	20 1/8	12 1/4
22		1417	Item 3	Criteria 2	20 1/8	12 1/4
23		2537	Item 4	Criteria 2	20 1/8	12 1/2
24		5241	Item 4	Criteria 2	20 1/8	12 1/2
25		9657	Item 4	Criteria 8	22 1/2	22 1/2
26		3521	Item 4	Criteria 8	22 1/2	22 1/2
27		4147	Item 4	Criteria 8	22 1/2	22 1/2
28		8547	Item 4	Criteria 8	20 1/8	12 1/4
29		9598	Item 5	Criteria 12	22 1/2	22 1/2
30		4147	Item 5	Criteria 12	20 1/8	12 1/4
31		2525	Item 5	Criteria 12	20 1/8	12 1/4
32		7478	Item 5	Criteria 12	20 1/8	12 1/4
33		9587	Item 6	Criteria 12	20 1/8	12 1/2
34		5748	Item 6	Criteria 10	20 1/8	12 1/2
35		9574	Item 6	Criteria 10	22 1/2	22 1/2
36		1543	Item 6	Criteria 10	22 1/2	22 1/2
37		3697	Item 7	Criteria 10	22 1/2	22 1/2
38		3527	Item 7	Criteria 10	20 1/8	12 1/4
39		8572	Item 7	Criteria 10	20 1/8	12 1/2
40
Equipment List

Find and match.xlsm
	A	B	C	D	E	F	G	H
1							Location:	Mars
2		Serial	Item nr	Criteria	Spec 1	Spec 2
3			Item 1	Criteria 9	22 1/2	22 1/2
4			Item 1	Criteria 7	22 1/2	22 1/2
5			Item 1	Criteria 9	22 1/2	22 1/2
6			Item 1	Criteria 7	20 1/8	12 1/4
7			Item 1	Criteria 7	22 1/2	22 1/2
8			Item 1	Criteria 7	22 1/2	22 1/2
9			Item 2	Criteria 7	20 1/8	12 1/4
10			Item 2	Criteria 7	20 1/8	12 1/4
11			Item 5	Criteria 12	22 1/2	22 1/2
12			Item 5	Criteria 12	20 1/8	12 1/4
13			Item 5	Criteria 12	20 1/8	12 1/4
14			Item 5	Criteria 12	20 1/8	12 1/4
15			Item 6	Criteria 12	20 1/8	12 1/2
16
17
Request List 1

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Match multiple columns in two worksheets and copy/paste missing information
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[arnejon]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Match multiple columns in two worksheets and copy/paste missing information
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Match multiple columns in two worksheets and copy/paste missing information

I have been stuck on this issue for some days now and I have searched through several forums but no luck. I will try to explain my issue as simple way as possible. I have a ws called “Equipment List” that is overview of an inventory. I also have several ws called “Request lists 1”, “Request...

chandoo.org