I have to copy data from a website, then paste it into Excel. It’s very time consuming, and I’d like to find a way to speed things up.
The webpage looks like this:
ID# Job# Job Info Address Date
111111 555555 Bill Billingham 2222 Street Way 3-3-11
Then I paste only the Job# and Address into Excel, like this:
Column A Column B Column C
555555 Pineapple 2222 Street Way
Is there some kind of software that would allow me to grab and copy only the Job# and Address down the whole webpage and then paste it into certain rows in Excel in Column A and C? I really like iMacros for other tasks, but I can’t find anything similar that would transfer between the internet and Excel. Or do you know of what these kinds of programs would be called?
Thanks so much!