match macro from a list

[John Caines]

Hi All,
I have a spreadsheet with a list of urls and data columns on a tab called 'Queries',, 5 columns of data (I'll upload spreadsheet so it helps visualise exactly what I have).
I have another tab in the workbook called 'my list'. This can list search terms (words) in Column A2 down,,, usually about 10 keyword phrases,, but could be many more,, IE up to 100

What I really would love to be able to do is have an tab sheet called' results',, and this could have a macro button.
When I press it, it looks at all the keyword phrases on sheet 'my list' (from A2 down) and then looks to find (match) the same phrases that would be in the sheet 'Queries' in column A2 down.

All matches (all data as well on the same row) would be put into sheet results (from A 2 down).

Simple eh!

Only, I'm not clever enough to know how to do / write this

Hope someone can help me out here.
I include an excel sheet attached with sample data...arhhhh,,, I see I cannot attach a sheet here.
here's a dropbox link

Queries-mrexcel-sample-sheet.xlsm

Shared with Dropbox

www.dropbox.com

Queries tab

Top queries	Clicks	Impressions	CTR	Position
شركة عقارات ابوظبي	1	1	100%	1
property group	1	1	100%	2
abu dhabi house for sale	1	1	100%	20
property management companies in dubai	0	150	0%	81.52
property management dubai	0	138	0%	59.54
property management in dubai	0	107	0%	69.65
property management company in dubai	0	70	0%	67.56
dubai property management company	0	61	0%	80.39
property management companies in uae	0	44	0%	56.3
property management company dubai	0	42	0%	72.45
mortgage broker dubai	0	37	0%	46
list of property management companies in dubai	0	36	0%	53.81
property management	0	33	0%	50.97
mortgage brokers in dubai	0	31	0%	36.23
ajman property for sale	0	24	0%	53.96
facility management	0	22	0%	91.77
mortgage brokers uae	0	20	0%	58.2
real estate management companies in dubai	0	20	0%	71.75
property management companies abu dhabi	0	19	0%	17.26
property management abu dhabi	0	18	0%	15.06
villas in abu dhabi	0	18	0%	80.78
property management companies dubai	0	18	0%	89.22
property management uae	0	17	0%	26.29

my list tab

Queries-mrexcel-sample-sheet.xlsm
	A	B	C
1	My Search Query
2	property management dubai
3	property management abu dhabi
4	mortgage consultants in dubai
5	real estate companies in ajman
6	propery management
7	ajman studio for rent
8
9
my list

results tab

Queries-mrexcel-sample-sheet.xlsm
	A	B	C	D	E	F	G	H	I	J
1	Matched Queries	Clicks	Impressions	CTR	Position
2
3
4
5										Maybe a clickable macro button here?
6
7
8
9
10
11
results

Hope this helps (hope this xl2bb addin has worked!

Many thanks in advance.
Hope it all makes sense

Best regards
john C

 

[John Caines]

Hi All,,
I actually forgot to show what the data to be returned would / should look like if you clicked the macro button in the 'results' tab!
I'd left that tab (results) blank!

Sorry about that.
Below is what I would hope could be returned from my above example.

Queries-mrexcel-sample-sheet.xlsm
	A	B	C	D	E
1	Matched Queries	Clicks	Impressions	CTR	Position
2	property management dubai	0	138	0%	59.54
3	property management abu dhabi	0	18	0%	15.06
4	mortgage consultants in dubai	0	9	0%	46.22
5	real estate companies in ajman	0	5	0%	35
6	propery management	0	2	0%	16
7	ajman studio for rent	0	1	0%	38
results

Example spreadsheet again is here

Queries-mrexcel-sample-sheet.xlsm

Shared with Dropbox

www.dropbox.com

Hope this all makes sense, and someone might be able to create some vba code to run this,,, it would be really helpful.

I don't think it's a huge vba problem, but I just don't know how to create this in VBA
If anybody needs any more info, please let me know
Many thanks all
Best regards
John C