Need to perform the following:
1- Select and open two or more workbooks.
2- Compare each sheet with identical name in all open workbooks.
3- Highlight all not existing values in cells within each Named Range with identical name within each identical sheet.
Notes:
1- Need to set Named Ranges to be dynamic.
2- Named Ranges are not contiguous.
3- Named Ranges already have merged cells.
Thanks for all assistance.
1- Select and open two or more workbooks.
2- Compare each sheet with identical name in all open workbooks.
3- Highlight all not existing values in cells within each Named Range with identical name within each identical sheet.
Notes:
1- Need to set Named Ranges to be dynamic.
2- Named Ranges are not contiguous.
3- Named Ranges already have merged cells.
Thanks for all assistance.