Hello
I hope I'm pasting enough code here. This isn't the entire code I have written, but hopefully enough to understand what I'm trying to do.
What I want to do is place the code into a loop, so that it runs until the values in column H are empty.
Basically, I'm copying a value that I place in column H, the code goes out to a web page and pastes that value and then searches for detailed information on that value. The information found is then copied and placed back into an excel worksheet and then I perform a search within excel worksheet and copy specific information to specific cell into a different worksheet.
I don't want to specify certain cells to copy and paste data... I want the code to grab info from H1.. etc.. then paste to I1, then do the same for H2 .. etc... paste to I2, that is if H2 is populated.
Thanks in advance for your assistance.. if more info or code is needed, I can supply.
Thanks
Bookmarks