Compare two cells in many workbooks

[wburbage]

I've been asked to help out with an issue we had in our group. Basically there's been a group of files created where the number on one tab is supposed to equal a number on another tab. There's roughly 300 of these files but I can break them into set of say 20.

What I thought I would put together is a workbook that has a main page where I can add in the file names of the files that need to be analysed. After I hit a consolidate button it would pull all the necessary data into a second tab where there's three columns... the file name, # from first cell (i.e, ws #1) and the # from the second tab (i.e, ws #2). So it would need to do a comparison of two cells, in two different worksheets in many workbooks.

Can anyone help out with this one?

Thanks,
Bill

[royUK]

The code here loops through all workbooks in a specific folder & cold be adapted to check the two cells, if they don't match either amend it or list the workbook name for later use.

[wburbage]

Thanks for the response but the code didn't post.