Forum Discussion
Automatic data import from web
I am trying to import https://baseballmonster.com/Lineups.aspx into an excel sheet in my workbook. I currently have it set up as a power query, which kind of works. I then have another sheet to organize the raw data. The problem I am having is every time https://baseballmonster.com/Lineups.aspx updates, the location of the information changes on the raw data sheet. When this happens I have to change the formula on the "Lineups" worksheet (where I organize everything) to point to the new cell location. It is extremely frustrating and time consuming. I am posting here in hopes of a more efficient and accurate way to pull the data. I am thinking that a VB script may be the way to go but not really sure where to start with that. If someone could direct me to a tutorial on how to tackle this or at least where to start, that would be much appreciated. https://drive.google.com/file/d/0B4U73bYwaDjZWDNNbWt2RTNlU0k/view of what I would like to accomplish. Thanks!