Matching Values in Two Sheets for Databasing

Hi all,

Another question I'm hoping to get answered by the community!

My need (see attached file to work with):
1. Check each cell value in sheet LWDB column A to the column A in sheet MyDB
2. If found take that cell values entire row of data (LWDB sheet), insert data row below found value (MyDB sheet) and offset one column (being data to start in column B)
3. If cell value in LWDB not found, add that value to list (with formatting in MyDB) to MyDB then add the LWDB row below it
4. Continue through loop to all items have been addressed.


My code:

Please Login or Register  to view this content.

My thoughts: I have had my code work for points 1 & 2 on sample of 5, however the matching code crashes due to processing past this amount! Would it be better to use some sort of Array or any other thoughts on cutting this down as the databasing could be up to 400 entries.

Appreciate the help

Some of the cells have duplicates values, so the return would also be 2,3 or 4 times.

Please Login or Register  to view this content.

AB33 - this code is perfect, worked through the data with no duplicates and in the position in under a second! Many thanks