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

 

[guerillaunit]

Can you post on a file hosting site and then share the link?

 

[Smitty]

Welcome to the Board!

If you follow the HTML Maker link in my sig you'll be able to post a shot of your sheet.

 

[st3ffl3sx13]

Smitty,

Is the link broken by chance because it is not letting me open the page.

 

[Smitty]

The link works fine for me, but here's the full url:

https://skydrive.live.com/?cid=8cffdec0ce27e813&id=8CFFDEC0CE27E813%21189

If that doesn't work, then you can PM me your e-mail address and I'll send you a copy.

 

[st3ffl3sx13]

I posted the excel spreadsheet to filefactory.com filesharing.

http://www.filefactory.com/file/47vcg8mbrjb3/n/example_xls

Here is the link that will take you directly to download it.

Hopefully I can get some help with this one.

Thanks,

-AS

 

[Smitty]

Unfortunately, I can't access external file sharing sites, but I'm sure someone else will be able to pick up on it.

 

[st3ffl3sx13]

Okay, I have it downloaded but could you run me thru the steps on how to generate the html or how I use it in general.. the word document does not suffice for me.

Thanks

 

[guerillaunit]

I am having trouble downloading from filefactory. Can you upload it to another site?

 

[st3ffl3sx13]

Hello,

I am new to file sharing so what is a filesharing site that you approve of and is free?