Importing data from webpage

slo_aussie

New Member
Joined
Jul 25, 2017
Messages
1
I have successfully imported a table no problems here...now the tricky part. Each row contains a hyperlink to a project page, which in turn has a hyperlink to a project - organizations page. Coincidently, on the project - organizations page there is a next button so it is also easy to jump from one project to the next...from each page I would need a row with the Project Code and Codes of organizations participating in that project.

Thus, I want to append a column(s) to the original table that lists all partner organizations for each specific project as detailed on the linked page.

Something like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]CODE[/TD]
[TD][FONT=Helvetica, Arial, sans-serif]S[/FONT]RA PROJECT TITLE[/TD]
[TD]PERIOD[/TD]
[TD]HEAD[/TD]
[TD]ORGANIZATIONS (ORG CODE)[/TD]
[/TR]
[TR]
[TD]J1-7148[/TD]
[TD]3D and 4D microscopy - development of new powerful tools in geosciences[/TD]
[TD]1.1.2016―31.12.2018[/TD]
[TD][FONT=Helvetica, Arial, sans-serif]Mauko Pranjić Alenka[/FONT][/TD]
[TD]0618; 1502; 1555 [/TD]
[/TR]
[TR]
[TD]V2-1513[/TD]
[TD]7.1.3 Model of the integration of Slovenian bicycle network[/TD]
[TD]1.10.2015―30.9.2017[/TD]
[TD][FONT=Helvetica, Arial, sans-serif]Žura Marijan[/FONT][/TD]
[TD]2690; 0792[/TD]
[/TR]
[TR]
[TD]V6-1509[/TD]
[TD]A concept of Hungarian-Slovenian dictionary: from a language resource to the user[/TD]
[TD]1.10.2015―30.1.2018[/TD]
[TD][FONT=Helvetica, Arial, sans-serif]Kosem Iztok[/FONT][/TD]
[TD]0507; 0581; 2565[/TD]
[/TR]
</tbody>[/TABLE]

Please help Excel pros I really don't have time to copy and paste the partners for each project (3000+) into my spreadsheet...is there a Macro/VBA trick that will allow me to import and match the partners (I don't care if it is their code, registration no. or name) for each specific project???

Many thanks
James
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Forum statistics

Threads
1,223,710
Messages
6,174,019
Members
452,542
Latest member
Bricklin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top