I have a simple request (I think...)
I have a list of url's in column A.
Columns B, C, D, E, F - is where I'll be looking to fill with extracted data.
I need a macro that will go through each URL from column A , and then look through the HTML Source View and I want to extract certain html code.
For example I want to extract anything between an <H1>H1 tags</H1>.
My task requires me to just go to a website, and copy and paste the values that are in the same spot.
So I'll have to copy the title tags and some extra text found in the very same spots.
There are more than 300 urls and this is going to be a waste of my time.
I'll need to be able to easily modify the variables in case I need to extract something else.
VBA/Macro solutions welcome (even formulas if possible)
I would appreciate this alot !
Thank You
Bookmarks