AutoFill Cells

[st3ffl3sx13]

Hello,

I have a worksheet where a user selects from a drop down box a 4 digit number in column F. I need a macro that will correspond the 4 digit number and autofill column J with a name of a server that the 4 digit number corresponds to. I have attached an example of it with this post. The 'request' sheet is what the user inputs. Sheet2 shows what the servers correspond to depending on what 4 digit number is entered. Hopefully this is enough info to assist with my problem.

I know I could use vlookup and drag the formula down, but because the people going to be using this are not very excel saavy, I will make a button to run the macro automatically. Also, there will be times where there are different amounts of rows of data so i would like a loop to run the macro until there is a blank row.

If anyone needs an example, I can email then an example spreadsheet of this since I cannot find a way to post an attachment on here.

Thanks,

-AS

 

[st3ffl3sx13]

http://www.ozgrid.com/forum/attachment.php?attachmentid=45117&d=1334066064

 

[guerillaunit]

Any site that doesn't require registration will do. The ozgrid link does require registration