So I am not sure if this is a Macro question that would require something like web scraping or if this can be done with general formatting. There is a website I pull data from that is updated weekly with new information. This data is on the side of the page and varies in size each week. Ideally I go to the website, copy all of the data and paste it into Excel and format it and then can easily compare the changes week-to-week with a macro or some conditioning. My question then, would it just be easiest to copy the data over each week and then fight the formatting? I am teaching myself Excel and VBA so I am not really sure how to tackle this. The data is not really in a table to start with which messed me up when trying to format. Any help would be greatly appreciated, thanks!