VBA macro with vlookup

leswes14

New member
Joined
Aug 19, 2013
Messages
1
Reaction score
0
Points
0
[FONT=Arial, sans-serif]Hello,[/FONT]


[FONT=Arial, sans-serif]I have three excel workbooks. I am trying to write a vba code in the TEMPLATE workbook. A "user form" has already been created to select open workbooks. [/FONT]


[FONT=Arial, sans-serif]I would like the user form in the TEMPLATE to run vlookup in the March report based on the categories from the February report when the "run vlookup" button is pressed. [/FONT]


[FONT=Arial, sans-serif]The heading "CATEGORY" will always be in column A, but sometimes it might be in A3, A7, or A9 and the numbers will start one cell underneath. The code would probably need to read the word CATEGORY somehow and offset to cell underneath it for the vlookup to begin. [/FONT]


[FONT=Arial, sans-serif]Does anyone know the code for this? ANy help would be appreciated. Thank you.[/FONT]
 

Attachments

  • February2013.xlsx
    8.6 KB · Views: 38
  • March2013.xlsx
    8.5 KB · Views: 25
  • the template.xlsm
    20.4 KB · Views: 54

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,200
Reaction score
16
Points
38
Excel Version(s)
365
cross-posted:
excelforum-dot-com/excel-programming-vba-macros/948584-vba-macro-with-vlookup-dot-html
thecodecage-dot-com/forumz/microsoft-excel-forum/214272-visual-basic-applications-macro-vlookup-dot-html

and elsewhere?
 
Top