Data Scrape from webpage

[arnoldchadd]

Hello,

I am currently working on a VBA Macro in order to scrape data from a webpage into an Excel spreadsheet. My problem originates from the type of webpage that I am accessing. I am accessing a webpage that is used to filter the type of information, in which I have a Favorite (preset), which is the URL that I have included in the code. Once I get to that page, the code selects the proper function to load the data onto another webpage. It is from this webpage that the data I need to import into the spreadsheet is located.

Here is a step by step breakdown of my macro and the bolded/underlined portion is what I need help with.

Macro initiated - > filter webpage opened - > selection of filter preloaded - > data loaded into another webpage - > webpage with data opened - > | need to transfer data to Excel |

If you could assist me or point me in a direction, I would appreciate it!

Best,

Chadd

Moderator's note: I am pretty sure you meant "scrape". I took the liberty of making the update because it affects the meaning. --6StringJazzer