I am in need of VBA code that performs the following function(s):
If any cell in Workbook 2, Sheet 1, Column B = any cell in Workbook 1, Sheet 1, Column B, then match value in Workbook 1, Sheet 1, Column A (A, B, C, etc) and enter matching result in Workbook 2, Sheet 1, Column A.
Result should be as follows on Workbook 2, Sheet 1:![]()
Please Login or Register to view this content.
As I am a complete novice with VBA code, I am not aware if macros can be executed to check against multiple workbooks. If not, I could always combine the data on one workbook, and use Sheet 1 and 2 - if necessary. Alternatively, I could have all the data in Sheet 1 only if that makes it even simpler.![]()
Please Login or Register to view this content.
Thanks for your time and input.
Bookmarks