Pull data into a unique table using VBA?

Hi Guys,

Basically i want to pull data from two different sheets (keyword and volumes + URLs) in the attached workbook and make it look like the output (example of output sheet) or something very similar in the example of output sheet.

So each URL from the URLs sheet has the all the related keywords sorted by search volume from the keywords and volumes sheet as shown in the example of output.

I think this is a doable with VBA but beyond my current excel expertise to mentally figure it out.

Any suggestions would be very much appreciated!

Cheers,
Chris

Hi, sorry your correct.

The URL should be: http://www.theupsidesport.com/women

Not http://www.theupsidesport.com/gforce-shorts-leopard.

I have reattached updated version with correction.

Thanks,
Chris