Good afternoon,
I believe this is quite a niche and complex ask and not sure if it is possible. I have 2 workbooks which will be called "Workbook 1" and "Workbook 2". Workbook 1 has items that I am trying to input into Workbook 2. I want to be able to read "MD500" from Workbook 1. "MD500" is called out 3 times in workbook 1, all of which are in column T. I want to return the text string in Column B of workbook 1 to column E of workbook 2. Workbook 2 has "MD500" in column G. Is there a formula or potentially a code in VBA that can help me automate this for hundreds of different callouts?
-Cheers
I believe this is quite a niche and complex ask and not sure if it is possible. I have 2 workbooks which will be called "Workbook 1" and "Workbook 2". Workbook 1 has items that I am trying to input into Workbook 2. I want to be able to read "MD500" from Workbook 1. "MD500" is called out 3 times in workbook 1, all of which are in column T. I want to return the text string in Column B of workbook 1 to column E of workbook 2. Workbook 2 has "MD500" in column G. Is there a formula or potentially a code in VBA that can help me automate this for hundreds of different callouts?
-Cheers
