Compare Workbooks

[ervierto]

I have two (actually more like 20) workbooks that are intended to have a lot of the same formulas in them, with different hand-entered data, resulting in different values for the formulas. Essentially, creating several workbooks from a top level template. On occasion, I have a need to update the template and I would like to make sure I get all the other workbooks updated the same way. Is there a way to compare two workbooks in such a way that the formulas are compared rather than the values of those formulas? For example Tab A, Cell A1 on every worksheet might be =Sum('Tab B'!$B$2:$B$45). The values on all the Tab Bs are different, but I want to make sure the formulas on Tab A are the same...
Thoughts?


(As an added bonus, I have a similar thing on a smaller scale with worksheets inside a workbook, I would like to be able to compare the formulas in two separate sheets within the same book...)


Thanks

 

[mole999]

i would probably use macro recorder to capture all the cells that need to be, place that in a module and then you can import the module into each workbook, run it and then you should all level