vLookup in a Macro

So I'm new to excel macros and the forum. Im trying to use a vlookup to enter employees names on a weekly report I download from our home office. I use a workbook I have called vLookup_2012 to do the look up. The problem is whenever we hire someone new I will add it to my vlookup_2012 workbook but the macro dosen't increase the table array for the vlookup. I have tried to use LastRow to see if there was a way to get the vlooup formula to increase based of the last row but I just don't know enough to get that to work. I have spent several hours on this forum looking for something to help but I don't even know what to look for. Please Help.

Ian

Could we have a look at your code so far and the structure of the workbook you're using?

OK, first off could you read the forum rules and use code tags when you post code, please?

Secondly, you've got a lot of lines of code in there that aren't doing anything useful. This is one of the drawbacks of using macro recorder.

Is this code actually in your VLookup_2012 workbook or is it in another book and is there a reason that one formula is looking in the range C1:C2 while the other is using C1:C4? Could they both use the whole of the C column for their lookup?

Sorry about the code. I know now.

There is a lot of useless code I do know that is from using the recorder. I am still learning the whole macro thing. I know I will get better.

Lastly the code is on my personal workbook. I need to use it repeatedly as I have to download a new report each week. Now as I look at this my real problem isn't the vlookup but rather this:

    Selection.End(xlDown).Select
    Range("D216").Select
    Range(Selection, Selection.End(xlUp)).Select
    Range("D2:D216").Select
    Range("D216").Activate
    Selection.FillDown
    Selection.Copy

I want to be able to select the last row select anything that might be below D216. Does this even make sense?

You want to be able to select everything from D2 to the last row with data in?

Range(Range("D2"),Range("D60000").End(xlUp)).Select

Is that it?

This is great. Now for another new guy question. What should your line of code replace? Where do I put it and what needs to come out?

I figured where to put it. Thank you, thank you, thank you! It works perfect.