Basically I am trying a find a code for the below requirement.
I have a Main file which calls set of files in a certain folder. When I click on Check format button I need to compare all the file mentioned in the Main file.
When comparing the Main sheet should create a new sheet with all the Failures of Format checking Results.
I mean which are NON-Arial. The newly created sheet should have 3 columns
1) File Name
2) Sheet Name
3) Cell Name - Cell Value - Arial Font is not matching
Main File Format of Sheet 1
This Sheet need to be created by Macro for Capturing the Failed Non-Arial ones.