How to get data from an excel file (selected columns) to join a master existing data worksheet last column. Match by email addresses

[vbanewbie68]

Hi

I get two files weekly, usually every Monday morning. I open a file called Pages excel file (csv), and then open a file called a Supporter file (csv) as well.

In the Pages file (at the end of the last column"AE") I need to get information from the Supporter's file such as Address, Town, Postcode etc.

Both files have the same headers for email addresses. I need to rely on a macro to search for matches for email addresses and if matches are found then add Address, Town, Postcode to join the Pages file, at the last column of the Pages.

Please find attached XL2BB dummy data of the Pages file and Supporters File to help you get a better picture.

I would appreciate it if you have any suggestions for improvement?

Please let me know if the above does not make any sense?

I look forward to hearing from you

Best Regards

V

Pages file (XL2BB)

fundraise-pages (1)Test.csv
	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	AB	AC	AD
1	Company Name	Person	Email	Title	Created Date	Url	Fundraiser Page ID	Event Page ID	Event Page Title	Event Page URL	Currency	Raised (inc. Gift Aid)	Target	Status	Donors custom code 1	Donors custom code 2	Donors custom code 3	Donors custom code 4	Cons ID	Appeal_Package ID	Fund ID	Tribute ID	Events custom code 1	Events custom code 2	Events custom code 3	Events custom code 4	Team page custom code 1	Team page custom code 2	Team page custom code 3	Team page custom code 4
2	London	Victoria John	victoria.tom@com.uk	Victoria Fundraising Page	14/06/2022 10:46	https://londonthon.feeworld.com/pf/victoria-chater-lea-2c6b8	257457				£	293.75	2500	Live
3	London	Jane Feern	jane2301@fee.com	Jane	20/05/2022 10:29	https://london.feeworld.com/pf/jane-harris	242457				£	0	2500	Live					514759	23CE01_A002	G00A01
fundraise-pages (1)Test

Supporter file (XL2BB)

Supporters (1) Test.csv
	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
1	Supporter ID	Title	First Name	Last Name	Email	Address	Town	Postcode	Country	Phone	Join Date	Currency	Lifetime Donations	Lifetime Gift Aid	Last Donation Date	Donors custom code 1	Donors custom code 2	Donors custom code 3	Donors custom code 4	Marketing Opt-in Answer	Marketing Opt-in Date	Email Opt-in	Phone Opt-in	SMS Opt-in	Post Opt-in
2	2614578	Ms	Char	Man	char.man@mail.co.uk	6,lentia Place, Greater London	London	SW78 8EU	United Kingdom		########	£	10	2.5	########					No	########	No	No	No	No
3	2601458	Mrs	Harry	Kings	harryk@FG.com	78, Well Walk, West Yorkshire	Manchester	M17 6EG	United Kingdom		########	£	50	12.5	########					No	########	No	No	No	No
4	2601451	Mrs	Victoria	John	victoria.tom@com.uk	6, Buckingham, Holland Lane	Bristol	RG1 78ft	United Kingdom		########	£	15	3.75	########					No	########	No	No	No	No
5	2600745	Miss	Jane	Feern	jane2301@fee.com	9, FhipFtead Close	Cheshire	GA45 4ff	United Kingdom		########	£	5	0	########					No	########	No	No	No	No
Supporters (1) Test