Hi,

Can some one help me with the below requirement?

Data in multiple workbooks inside a single folder to be compared(data in each and every cell) and result to be populated in a workbook Template with pass or fail status if any mismatch in data in any of the cells.
No of workbooks varies depending on the requirement.
Work books to be compared will be of same name with slight change and data range inside both the workbooks will be same.

In detail : I have workbooks inside a folder named "automation"
abc_exp_1.xls
abc_act_1.xls
abc_exp_2.xls
abc_act_2.xls
abc_exp_3.xls
abc_act_3.xls
abc_exp_4.xls
abc_act_4.xls
abcd_efgh_exp_1.xls
abcd_efgh_act_1.xls
abcd_efgh_exp_2.xls
abcd_efgh_act_2.xls
abcd_efgh_exp_3.xls
abcd_efgh_act_3.xls
abcd_efgh_exp_4.xls
abcd_efgh_act_4.xls

I have a master workbook inside the same folder "automation" named - Testresult.xls along with above mentioned xls files

Task:Compare data from similar named xls files and show o/p as pass/fail on Template as per the scenario(suffix) 1 , 2 , 3 , 4 ...

Note: I will have expected results for scenarios (1/2/3...)for category (abc / abcd_efgh / ....) in one workbook and actual result in another workbook, thats were workbooks are differentiated with "exp / act" in the name suffixed with scenario no and prefixed category name.

No of categories and scenarios will be dependent on requirement.

Eg in detail : Data to be compared between two work books are : abc_exp_1.xls and abc_act_1.xls
like wise data to be compared between next set of two work books are : abc_exp_2.xls and abc_act_2.xls
in similar front data to be compared between all their respective pair(exp/act) of work books and final output to be entered on master template sheet as pass/fail if any mismatch found.

Any help would be greatly appreciated !!!

Thanks,
Kiran