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
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