[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]
[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]
