Hi,
VBA Newbie seeking help! I'll try to describe the problem I have as best as I can:
Column B - A dynamic range that is auto-populated. The string that is contained in this range is referencing a specific workbook.
Column G - Here I want to have a formula inserted to use vlookup and display a value from the workbook referenced in column B. I want the formulas to be auto-populated to the same number of rows that are listed in Column B.
With the code below I am able to return the desired value in Column G, but only for the top row. Each of the following rows only displays the vlookup for the top workbook in column B. Is there anyway I can make the range dynamic when the formulas auto-populate in column G?
Any help/suggestions is greatly appreciated.Please Login or Register to view this content.
Thanks!
Bookmarks