With the help from this forum I was provided this macro solution.
I wanted to report that this macro worked great except for one quirk. I needed to add this macro in the Code_Mkt_table source file as the destination files are only temporary. I changed the macro name, range column, code_mkt range and destination column. When I run the macro from the active destination workbook it always prompts me to select the CODE_MKT_table file where it resides on the drive. I was under the impression if the source file was open, the macro would work and not prompt me like this. What am I missing in the vlookup array? As it works now once I select the CODE_MKT file the results appear instant and accurate on the destination workbook file. I just don't know why I have to point to the CODE_MKT file each time.
Thanks for your time in assisting me.
Jim
Bookmarks