Results 1 to 2 of 2

Thread: VBA macro with vlookup

  1. #1

    VBA macro with vlookup



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,


    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.


    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.


    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.


    Does anyone know the code for this? ANy help would be appreciated. Thank you.
    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,481
    Articles
    0
    Excel Version
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •