I have two sheets
I would like to add to my personal.xlsb a procedure which cover the following requirements:
1. Inputbox “Select initial range to compare related to first sheet to compare”
2. Inputbox “Select initial range to compare related to second sheet to compare”
3. Create a Comparison sheet as attached in which true/false values should be displayed based on = formula.
4. Highlight false values.
I attached dummy file.
-True, False values should go till the last used Range, related to Sheet1 & Sheet2. The best is to identify this by checking last used range of Sheet1 and Sheet2. If one of the sheet have more used range this should be the reference
-If comparison sheet already exists, delete it.
If you have questions please contact me