Countblank - Need code to update countblank numbers as data is updated

Hello,

I have a workbook that compares each spreadsheet against a list of required fields in another workbook and returns a row of countblanks for each required field. My boss has asked if I could have the countblank numbers change as we update the data in the blank fields. I have attached the spreadsheet for your reference. The current code is listed below. Any assistance would be greatly appreciated.Excel Compare Test Updated.xlsx

Please Login or Register  to view this content.