Student for life
New Member
- Joined
- Sep 16, 2014
- Messages
- 23
Hello everyone,
I am trying to download a bunch of tables from a site (allowed by the site administrator). I can use the site's filters/search tools and get all my data by year on a web page. However I need 20 or so years worth of data, so I have to click on each year one by one to access the corresponding table for that year, then copy and paste each table to an excel sheet. Is there a way to do this quickly in Excel. BTW, I am using MS Excel Professional Pro 2016.
Thank you in advance.
I am trying to download a bunch of tables from a site (allowed by the site administrator). I can use the site's filters/search tools and get all my data by year on a web page. However I need 20 or so years worth of data, so I have to click on each year one by one to access the corresponding table for that year, then copy and paste each table to an excel sheet. Is there a way to do this quickly in Excel. BTW, I am using MS Excel Professional Pro 2016.
Thank you in advance.