Workbook A has two sheets, one of which (not the active sheet) has a named range called "ObjectCodes" to be used for VLOOKUPs.
Workbook B has a column that needs to be filled with the results of the VLOOKUP. The problem is that I need the row number of the lookup value to be dynamic (so I can say "A2", then "A3", then "A4", etc) but retain the vlookup to be on a different workbook (which will be open when the VB code is run). The reason for this is there are a ton of calculations that need to be performed per line (and putting in the formulas would cripple the sheet), so I am having it cycle through them with a For...Next loop to just fill in the blanks.
Example Code as presently written, which I know doesn't work:
The output should be the first four characters from Column AK, then a " - ", then the output of the VLOOKUP from Workbook A. The active workbook and sheet should never move away from Workbook B.
My brain hurts at this point, so any input would be helpful.
Bookmarks