i have almost 100 folders including subfolders and each of it have one workbook each . each workbook has 7 sheets inside . i want to compare the sheets in each workbooks and need to highlight if there is any differnce. can help me wih a code so as to do this . or can i use vlookup to solve this ? Looking forward for a faster reply as this is for my project ..