Hello,

I would like to create a VBA/macro that automatically updates my spreadsheet with the proposed lineups when the spreadsheet is refreshed. I've tried using the power query editor without any success retrieving the data from the website. The power query editor gave me options for Document (Kind = element, name = HTML , Children = table, and text = null) and table 0, which shows a table for social media. Can someone help me with a VBA to grab each applicable table?

Thank you