Website form filler, not for passwords and stuff

I have this online form of sorts that has a bunch of Site names in the first column and then a box next to it that needs the site code that matches the name. I have the master list in Excel which is a good 1000 sites with their codes. Is there any software that will look at the text then search a list and plug in the number or is that only possible with some kind of cgi or sql thing.

 

I don't know of any software that will do this for you, but it may be possible to write an Excel macro to do it??

You'd have to elaborate on what you're doing for us to help you further. What's a "site code"? Is it an arbitrary code for the website? Its IP address?

 

Its just a random number that was created that stands for the site. Down the line in our software it refers to the number to create other reports by itself. But this actual entering of the number is all manual.



In my excel sheet, one column is the "Name" and the 2nd is "Code." The category isn't important as I have those all memorized after doing this so much.

So any idea?

Lemme know if I need to explain more.

Thanks
Warfarin