I'm working on a project and am stumped on how to do a certain task. I've imported some data from a webpage that will refresh at times thus moving the information I need to extract from it around. What I need to do is create a macro that will extract prices that will always follow a certain word. My knowledge of VBA is very limited and I really have no clue as how to do this.
I've attached the file the page I need to extract data from to better illustrate what I need to do. My macro must extract the prices under the Slaughter Bulls line coming after 1500-2000 lbs. Like I stated the prices will always follow the lbs but could be in different lines when refreshed.
The sample I sent was in excel 2003 but the project is actually using excel 2007 if that makes a difference.
Thanks in advance
Bookmarks