Hey Merc,

Do the files contain sensitive data? If not could you post the books? If so.....do you think you could create a dummy example of what you have and what you want the outcome to be?

I think I follow what you're trying to do, but I got lost at the array section. I've never used the "Workbooks.OpenText" command. And I'm not sure why you are writing "OpenText" for an xls document and not a txt or doc document. Or maybe I'm just not following all together but I'm trying .

I'm sure there can be an easier way to do this. And I'm more than willing to help.