Macro to return all matches from a list and populate sheet

[davio565]

Hi Guys,

I'm having trouble with getting this one to work so turning to the experts.

So I have a list of data which is big (~300k rows and 15 columns). I have another list of names which is about 500 long.

So say the data is in Sheet 2 and my 500 names in Sheet 1, down column A.

I am wanting a macro to search through the data for each name and return the data from columns D to I from each row that matches. Perhaps for the most recent 20 matches (data is from old to new so the macro would work upwards).

Results would returned to sheet 1 to the right of the name. B1 to G1 would be filled with the first matched names data. H1 to M1 would be the second matched names data etc. This then the same for the name in A2, A3 etc.

I realise this may take a little time to execute but would anyone have any ideas?

I have found some code which does what i want however each name would need putting into the code which isn't feasible when there are 500 names and they change daily.

Any help much appreciated.

Thanks

 

[jmacleary]

Hi there. You say:

each name would need putting into the code

but if youve found code that does what you want, why not just load the names into it from Sheet1?

 

[davio565]

Hi there,

As i mentioned this is a list of 500 names that changes daily so changing these in the macro everyday sort of defeats the purpose of automating the solution.

 

[Yongle]

You did not understant what @jmacleary is saying

You said you have working code - so it could be modified to loop through the values in sheet 1

So either do that yourself or post that code if you require help