Greetings,
I am currently working on a project with 1500 workbooks. As each workbook is updated, a column in the tracking status of each workbook is changed to "Complete" using data validation.
At the bottom of the worksheet, formulas are written to give the percentage of each catagory: "Not...