shamamallama
New Member
- Joined
- Jul 2, 2017
- Messages
- 1
Hi everyone, very new VBA user here.
I'm trying to copy and paste information from multiple pages. So I'm looking at a site on pension schemes. There are 150 pages of schemes, with 20 or so schemes on each page. To get information from each one, you need to click the name of the scheme and then you get a table of information like plan provider, service provider, etc.
What I'm trying to do is:
1) List out all the schemes in an Excel table
2) Extract the data from the pages you click into so I can have a column for plan provider, service provider, etc next to the Scheme name in Excel.
Is there any way to do this or am I stuck clicking into pages and pages of info and copy/pasting
Any help is appreciated, thank you!
I'm trying to copy and paste information from multiple pages. So I'm looking at a site on pension schemes. There are 150 pages of schemes, with 20 or so schemes on each page. To get information from each one, you need to click the name of the scheme and then you get a table of information like plan provider, service provider, etc.
What I'm trying to do is:
1) List out all the schemes in an Excel table
2) Extract the data from the pages you click into so I can have a column for plan provider, service provider, etc next to the Scheme name in Excel.
Is there any way to do this or am I stuck clicking into pages and pages of info and copy/pasting