Quote:
Originally Posted by batman1
Sub demo in Module1
|
Batman,
While you matched the output of the last test file, your process when run on the actual data file returned 21 rows when I should have returned 39.
I think the problem is your output is limited to the number of unique file names you find in NDS_SHEET. That is not the intended process.
The intended process is to look at every row in the RS_SHEET
For Every row look at Every row in the NDS_SHEET
If the row NDS_SHEET File Name (column 8) is InStr(RS_SHEET column 2)
Then create record in Overlay.
I'm currently doing that process just in a different way and I get the result I need. It is faster than looping through every row and every row but still takes time.
Your process seems faster but it isn't returning all the required results.
I've attached another file which I think will help you see what I am talking about if you still have interest. Thank you.