I have no problem making a sample sheet if necessary, but I almost think that might confuse you even more because I still haven't even really gotten a start on it because I am not sure what to do just yet.

Let me explain more what the full idea is and see if anyone knows of a solution.

I get in sheets each day that have information that I use to cross reference with spreadsheets I already have to fill in the blanks. For instance, I will get in a sheet that has a brand name in column AC. Next to it, in column AB, is where the Brand ID is supposed to go (that is a numeric key that our database can read). The brands will always be in column AC, but they may not always be written exactly how they are supposed to (because people make mistakes). So, I have to copy the brand then open up a spreadsheet that has all of the Brands and Brand IDs on it (columns A and B), then search column A to find the Brand I am looking for. Once found, I copy and paste both the brand and the brand key back into my original sheet.

This can be quite a task, especially when there is a mispelling on the original sheet. What I am hoping to do is make a template which will essentially have all of these brands and brand keys in some sort of list format that I can simply have both the template and the original sheet up at once and work on the template until all the information necessary is filled in (there are quite a few others like this as well), and then I can write a macro that will take everything on the template and paste it into the appropriate cells on the original sheet.

The problem with having this huge list on my template is that it takes forever to scroll to the correct brand and I want this to be the simplest method possible. And using the Find pop-up just takes too long. I like the idea of using code to have it autofilter the list as I am typing, but I really don't want the list to be directly below the cell in which I am typing in, if that makes sense.

Hopefully this gives you a better idea of what I am looking for.

Thanks!