I have two very large databases. One comprises two full sheets and the other comprises 4 full sheets. The two sheet workbook utilizes columns A:X, while the four sheet workbook utilizes columns A:R.
I am seeking assistance with performing the following ...
Obtain a serial number in Workbook #1 / column B and match it with a serial number in Workbook #2 column B. When the match is complete, copy the data Workbook #2 in column E / same row as serial number and paste it into Workbook #1 column E.
When performing the search in Workbook #2 it may be necessary for all 4 sheets to be searched in order to locate the matching serial number.
So to state it some what more concisely ... Search Workbook #2 (possibly all four sheets) for serial number from Workbook #1. Match located ... copy data same row / column E and paste in Workbook #1 column E.
NOTE :
Now here is the challenge I am facing with my computer. It has one of latest cpu's and 32 gb of ram. BUT ... the amount of data I am faced with the above stated goal will most assuredly overwhelm my machine. I've already experienced Excel freezing up just trying to get all the data pasted into the sheets of both Workbooks.
I am seeking a highly efficient vba macro that can take my machine by the hand and slowly walk it through all the required steps of processing the Workbooks.
I am also very open to using something other than VBA if there is a guarantee it will work as desired.
Suggestions ?
Search image :
Search n Copy Image.jpg
Final product image :
Final Result.jpg
Bookmarks