I just don't know where to begin with this macro so I'm hoping that someone has tackled something similar and can help me out.

I'm copying over 100 text strings (one at a time) from various web sources directly into an excel spreadsheet. My browser window is open and so is my excel speadsheet (Excel 97). Text string 1 goes into cell A1, Text string 2 to cell A2 and so on. To avoid opening and closing windows, I'd like to do each copy and paste function via macro with one key stroke and to have the new info paste directly into the next available cell in the selected spreadsheet column.

There is one additional important step I'd like the macro to perform. I would like to check that a new text string has not already been added to the file. If it has, I'd like the macro to message that the string already exists and to not add it a second time.

I'd appreciate any help offered. Thanks