Hello I have two workbooks called "master" and "division".
The "division" workbook has the same sheet names as the ones found in the "master" workbook.
The "master" workbook has other sheets which do not exist in the "division" workbook.
I am looking for a macro which will go through the sheets of the "division" workbook and transfer via a vlookup function the "License" numbers to the "master" workbook.
I attach a sample of the workbooks to make this more clear.
Please let me know if I have to clarify this further.
thanks for your help
andy
Bookmarks