I am trying to create a Macro which will allow me to select the first value in a column in excel and place it in the search box on this website http://www.ean-search.org. Recover the result,which is displayed below the search box in 2 columns, and paste into the same spreadsheet as the initial value in a different cell, then continue for all values in the same column untill finished. I have got as far as managing to selct and paste the first value but do not know how to be able to copy and paste the result and then repeat down the column. All assistance would be appreciated greatly.
Novice Mike
Novice Mike
