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.

Attached Files

Overlay Tool Sample Data BM.xlsm (117.7 KB, 4 views)

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/