Quote:
Originally Posted by gmaxey
I tried to attach the file previously but it is too big. I was able to get your code to run but the result when run on my test file only returns 22 rows when it should return 43. I was able to post the test file here:
Identify Matches between Sheet Columns (see post #6)
It is a pretty complicated process (for me at least) and the example I asked about was a feeler to see if there was a way to do it without loop through all of the rows (speed enhancement). I believe with some slight mods that your approach might work, but it stills does a lot of looping and I'm not sure if in the end there would be that much improvement in speed.
Thank you for sharing your ideas. I have used a dictionary before but clearly not as proficient with them as you. Well done!! |
1. I understand that the value to search is in Sheet NDS_SHEET, but exactly in which column? Maybe it's just part of the cell value?
For example, let's take row 5 in NDS_SHEET, the value to search for = ???
2. We already have the value to search for, but where do we search in sheet REF_SHEET?
It is best to attach a file:
1. NDS_SHEET with 20 rows of data
2. REF_SHEET with 100 rows of data
3. Manually enter all matches in the RESULT sheet