macro for vlookup (almost completed)

**leswes14** · 08-23-2013, 10:09 AM

Greetings,

I have three excel workbooks. I am trying to write a vba code in the TEMPLATE workbook, which is almost finished. A "user form" has already been created to select open workbooks in the TEMPLATE.

I would like the user form in the TEMPLATE to run vlookup in the current month's report based on the categories from previous month's report when the "run vlookup" button is pressed in the TEMPLATE. The vba code is there, but I think these two lines need to be altered -

Workbooks("March2013-7.xlsx").Activate
.Formula = "=VLOOKUP(A" & ActiveCell.Offset(1).Row & ",'[February2013-1.xlsx]Sheet1'!$A$4:$B$200,2,FALSE)"

Right now, these two codes are set for specific reports (March2013-7.xlsx and February2013-7.xlsx) but they need to be set for whatever report is selected in the "userform" table. It won't always be march and february as there are other months of the year

Can someone please help me out with this? Thank you so much!