Comparing data from worksheets in a folder

[excellearner241]

So I am trying to compare and match data from 2 workbooks in a folder at once. There is about 700 workbook files in the folder. For example: compare the cells in workbook 2 to workbook 1 and the cells in workbook 2 that are not in workbook 1, paste the cells and show the number of cells. The process should repeat for Workbooks 3 and 2, then workbooks 4 and 3, then 5 and 4, and so on, until the last workbook.

 

[ajetrumpet]

that's a pretty long operation, sir. I do know, unless i'm mistaken, that you can write formulas in cells in 1 workbook that pull data from cells in workbook 2 if both workbooks are open. you can also obviously copy and paste in that regard when both are open. but for what you want, I don't see that you have any other choice than to write code to loop every book in the folder, open them one by one, along with opening your "source"/"referencing"/"template" book and keeping it open, and then using the code to do the work. I gave another person a sample of how to open multiple books (csv files) like this that are in a single location in this thread: How to transpose multi CSV files in a folder using VBA into 1 excel file. also, allen browne's site has so much vba info on it you can literally spend years exploring it. here's one of his pages that is relevant to your needs: Microsoft Access tips: List files recursively. in that code, you would have to modify the primary routine to open workbooks rather than just list file names, but that's easy to change.

see what you can gather from those resources.