I have a "master" worksheet with 11 columns of data, including a column of symbols in col. A (up to 100 symbols).
I have another workbook, whose col. A contains my "master" symbols and many more (up to 500 symbols).
I want to use the symbols from "master" 1 at a time, find the matching symbol in the bigger workbook, take the value in col. J for the matching symbol, and put that value col. K of "master".
Also, in doing this, do both workbooks have to be open, or can the bigger one be closed?
Thanks for any help with the above.
I have another workbook, whose col. A contains my "master" symbols and many more (up to 500 symbols).
I want to use the symbols from "master" 1 at a time, find the matching symbol in the bigger workbook, take the value in col. J for the matching symbol, and put that value col. K of "master".
Also, in doing this, do both workbooks have to be open, or can the bigger one be closed?
Thanks for any help with the above.