Move COntact Information to matching file

[Truiz]

Hello,

I need some help with a Macro, I have information as the below Table (not formatted as a table)

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
1	Login_Name	Campaign Name	External Id	Full Name	First_Name	Last_Name	Job_Title	Department	Email	UserDID	ContactId	Company Name	AccountDID	Phone	Address1	Address2	City	State	Zip	Country	Lead Score	Generate Lead	Notes	Custom 1	Custom 2	Custom 3	Status
2	flname	GPS Blueprinting		Fname1 Lname1	Fname1	Lname1	Job Title		email1@domain.com			Company Name 1		1234567891	Street Address 1		City 1	MI		USA		No
3	flname	GPS Blueprinting		Fname2 Lname2	Fname2	Lname2	Job Title 1		email2@domain.com			Company Name 1		1234567892	Street Address 2		City 2	MI		USA		No
4	flname	GPS Blueprinting		Fname3 Lname3	Fname3	Lname3	Job Title 2		email3@domain.com			Company Name 1		1234567893	Street Address 3		City 3	MI		USA		No
5	flname	GPS Blueprinting		Fname4 Lname4	Fname4	Lname4	Job Title		email4@domain.com			Company Name 1		1234567894	Street Address 4		City 4	MI		USA		No
6	flname	GPS Blueprinting		Fname5 Lname5	Fname5	Lname5	Job Title 3		email5@domain.com			Company Name 1		1234567895	Street Address 5		City 5	MI		USA		No
7	flname	GPS Blueprinting		Fname6 Lname6	Fname6	Lname6	Job Title 4		email6@domain.com			Company Name 1		1234567896	Street Address 6		City 6	MX		MX		No
8	flname	GPS Blueprinting		Fname7 Lname7	Fname7	Lname7	Job Title		email7@domain.com			Company Name 1		1234567897	Street Address 7		City 7	MI		USA		No
9	flname	GPS Blueprinting		Fname8 Lname8	Fname8	Lname8	Job Title 5		email8@domain.com			Company Name 1		1234567898	Street Address 8		City 8	MI		USA		No
10	flname	GPS Blueprinting		Fname9 Lname9	Fname9	Lname9	Job Title 6		email9@domain.com			Company Name 1		1234567899	Street Address 9		City 9	MI		USA		No
11	flname	GPS Blueprinting		Fname10 Lname10	Fname10	Lname10	Job Title		email10@domain.com			Company Name 1		1234567900	Street Address 10		City 10	MI		USA		No
12	flname	GPS Blueprinting		Fname11 Lname11	Fname11	Lname11	Job Title 7		email11@domain.com			Company Name 1		1234567901	Street Address 11		City 11	MI		USA		No
13	flname	GPS Blueprinting		Fname12 Lname12	Fname12	Lname12	Job Title 8		email12@domain.com			Company Name 2		1234567902	Street Address 12		City 12	AZ	85284	USA		No
14	flname	GPS Blueprinting		Fname13 Lname13	Fname13	Lname13	Job Title		email13@domain.com			Company Name 2		1234567903	Street Address 13		City 13	IN	46322	USA		No
15	flname	GPS Blueprinting		Fname14 Lname14	Fname14	Lname14	Job Title 9		email14@domain.com			Company Name 3		1234567904	Street Address 14		City 14	TN		USA		No
16	flname	GPS Blueprinting		Fname15 Lname15	Fname15	Lname15	Job Title 10		email15@domain.com			Company Name 3		1234567905	Street Address 15		City 15	PA		USA		No
17	flname	GPS Blueprinting		Fname16 Lname16	Fname16	Lname16	Job Title		email16@domain.com			Company Name 3		1234567906	Street Address 16		City 16	DE		USA		No
18	flname	GPS Blueprinting		Fname17 Lname17	Fname17	Lname17	Job Title 11		email17@domain.com			Company Name 3		1234567907	Street Address 17		City 17	PA		USA		No
19	flname	GPS Blueprinting		Fname18 Lname18	Fname18	Lname18	Job Title 12		email18@domain.com			Company Name 4		1234567908	Street Address 18		City 18	MI		USA		No
20	flname	GPS Blueprinting		Fname19 Lname19	Fname19	Lname19	Job Title		email19@domain.com			Company Name 4		1234567909	Street Address 19		City 19	MI		USA		No
21	flname	GPS Blueprinting		Fname20 Lname20	Fname20	Lname20	Job Title 13		email20@domain.com			Company Name 4		1234567910	Street Address 20		City 20	MI		USA		No
22	flname	GPS Blueprinting		Fname21 Lname21	Fname21	Lname21	Job Title 14		email21@domain.com			Company Name 4		1234567911	Street Address 21		City 21	MI		USA		No
23	flname	GPS Blueprinting		Fname22 Lname22	Fname22	Lname22	Job Title		email22@domain.com			Company Name 4		1234567912	Street Address 22		City 22	MI		USA		No
24	flname	GPS Blueprinting		Fname23 Lname23	Fname23	Lname23	Job Title 15		email23@domain.com			Company Name 4		1234567913	Street Address 23		City 23	MI		USA		No
25	flname	GPS Blueprinting		Fname24 Lname24	Fname24	Lname24	Job Title 16		email24@domain.com			Company Name 4		1234567914	Street Address 24		City 24	MI		USA		No
26	flname	GPS Blueprinting		Fname25 Lname25	Fname25	Lname25	Job Title		email25@domain.com			Company Name 4		1234567915	Street Address 25		City 25	MI		USA		No
27	flname	GPS Blueprinting		Fname26 Lname26	Fname26	Lname26	Job Title 17		email26@domain.com			Company Name 4		1234567916	Street Address 26		City 26	MI		USA		No
28	flname	GPS Blueprinting		Fname27 Lname27	Fname27	Lname27	Job Title 18		email27@domain.com			Company Name 4		1234567917	Street Address 27		City 27	MN		USA		No
29	flname	GPS Blueprinting		Fname28 Lname28	Fname28	Lname28	Job Title		email28@domain.com			Company Name 5		1234567918	Street Address 28		City 28	MI		USA		No
30	flname	GPS Blueprinting		Fname29 Lname29	Fname29	Lname29	Job Title 19		email29@domain.com			Company Name 5		1234567919	Street Address 29		City 29	MI		USA		No
31	flname	GPS Blueprinting		Fname30 Lname30	Fname30	Lname30	Job Title 20		email30@domain.com			Company Name 5		1234567920	Street Address 30		City 30	MI		USA		No
32	flname	GPS Blueprinting		Fname31 Lname31	Fname31	Lname31	Job Title		email31@domain.com			Company Name 5		1234567921	Street Address 31		City 31	VA		USA		No
33	flname	GPS Blueprinting		Fname32 Lname32	Fname32	Lname32	Job Title 21		email32@domain.com			Company Name 5		1234567922	Street Address 32		City 32	MI		USA		No
34	flname	GPS Blueprinting		Fname33 Lname33	Fname33	Lname33	Job Title 22		email33@domain.com			Company Name 5		1234567923	Street Address 33		City 33	MI		USA		No
35	flname	GPS Blueprinting		Fname34 Lname34	Fname34	Lname34	Job Title		email34@domain.com			Company Name 5		1234567924	Street Address 34		City 34	MI		USA		No
36	flname	GPS Blueprinting		Fname35 Lname35	Fname35	Lname35	Job Title 23		email35@domain.com			Company Name 5		1234567925	Street Address 35		City 35	MI		USA		No
37	flname	GPS Blueprinting		Fname36 Lname36	Fname36	Lname36	Job Title 24		email36@domain.com			Company Name 5		1234567926	Street Address 36		City 36	MI		USA		No
38	flname	GPS Blueprinting		Fname37 Lname37	Fname37	Lname37	Job Title		email37@domain.com			Company Name 5		1234567927	Street Address 37		City 37	NY		USA		No
39	flname	GPS Blueprinting		Fname38 Lname38	Fname38	Lname38	Job Title 25		email38@domain.com			Company Name 6		1234567928	Street Address 38		City 38	TN		USA		No
40	flname	GPS Blueprinting		Fname39 Lname39	Fname39	Lname39	Job Title 26		email39@domain.com			Company Name 6		1234567929	Street Address 39		City 39	NY		USA		No
41	flname	GPS Blueprinting		Fname40 Lname40	Fname40	Lname40	Job Title		email40@domain.com			Company Name 6		1234567930	Street Address 40		City 40	TN		USA		No
42	flname	GPS Blueprinting		Fname41 Lname41	Fname41	Lname41	Job Title 27		email41@domain.com			Company Name 7		1234567931	Street Address 41		City 41	MI		USA		No
43	flname	GPS Blueprinting		Fname42 Lname42	Fname42	Lname42	Job Title 28		email42@domain.com			Company Name 7		1234567932	Street Address 42		City 42	IA		USA		No
44	flname	GPS Blueprinting		Fname43 Lname43	Fname43	Lname43	Job Title		email43@domain.com			Company Name 7		1234567933	Street Address 43		City 43	MI		USA		No
45	flname	GPS Blueprinting		Fname44 Lname44	Fname44	Lname44	Job Title 29		email44@domain.com			Company Name 7		1234567934	Street Address 44		City 44	IL		USA		No
46	flname	GPS Blueprinting		Fname45 Lname45	Fname45	Lname45	Job Title 30		email45@domain.com			Company Name 7		1234567935	Street Address 45		City 45	OH		USA		No
47	flname	GPS Blueprinting		Fname46 Lname46	Fname46	Lname46	Job Title		email46@domain.com			Company Name 7		1234567936	Street Address 46		City 46	IA		USA		No
48	flname	GPS Blueprinting		Fname47 Lname47	Fname47	Lname47	Job Title 31		email47@domain.com			Company Name 7		1234567937	Street Address 47		City 47	IA		USA		No
49	flname	GPS Blueprinting		Fname48 Lname48	Fname48	Lname48	Job Title 32		email48@domain.com			Company Name 7		1234567938	Street Address 48		City 48	IA		USA		No

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

New_Lead_Template​

What I have to do is copy the rows of information based on the company name I have a file for each company so for example all the rows containing Company Name 1 are going to be copied to a file called "Company Name 1 2016" inside that workbook there are several sheets I want to move them to a sheet called "Master Sheet" on the last blank row.

I have read a few post related to this but I can't get to work the company name condition

 

[Truiz]

Maybe some help for looping thru the rows could point me to the right direction....

 

[Truiz]

No one has a clue?

 

[Truiz]

Help

 

[Truiz]

Maybe I have to much daata on my example is that confusing?

 

[Truiz]

Does anyone have a clue