Hello,
I was hoping someone could point me in the right direction, I have a spreadsheet i am trying to get going but in order to do so i need a macro or VBA to extract a lot of information from external sources to put into the spreadsheet, basically the spreadsheet has one column which has links in it "B2 - B16643" then I have another two columns (C & D) which i want to store the data in from the link, basically when the webpage loads for the link in the cell Bx, it has two or three lines on it, all just text, so i would like to only copy the first two lines, the first line would go into cell Cx where x is the row number, and the second line of the website would go into cell Dx again where x is the row number, and it would loop through the rows until it got to the end. The data is different for the different links on each line though, so i don't think i could just do a direct web import otherwise i would have given that a go.
Does anyone has a similar example where it grabs data from a website and puts the text into cells, the lines are directly at the top of the page, and they are the only writing on the page, no images or anything else.
If anyone could help it would be greatly appreciated.
Bookmarks