![]() ![]() if there are no similar tabs, then i should get a message that "Sheet name" is not found in Workbook b. After that go to the next sheet of work book A and find the similar tab in b and so on. if the sheet names are same, then it should compare and highlight differences. it should first go to the first tab in the workbook "A" and search the excel sheet with similar tab name in work book "B". For example: My work books may contain 30-40 sheets. But I need an advanced macro which compares two workbooks with similar tabs. Hello,Can some one help me providing VBA code to compare two workbooks with similar tabs and highlight the differences.The below code which I found from a blog helps me to highlight two sheets. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |