Hello and thank you for reading this message.
In Excel, I've set up various Macros. But extracting data from a website is new to me, though I've found where several methods in Excel are. Can you help? I'd like to set up a macro that extracts the same section of data from different pages of a specific website and copy the data into excel.
Here is an example of one page from the website :
tax.service.gov.uk/business-rates-find/summary/16751684000?uarn=267529075
All the pages on the website have the same format. So I'd like to create a macro that works with whichever page is displayed and then copies to a new excel page the data below the heading "Parts of the Property" until and including the last full line of data ie up to and excluding the column totals.
Any ideas will be of help.
Thank you again for reading this message.
Bookmarks