Dump.xlsx (8.4 KB)
Master.xlsx (9.0 KB)
I have Dump and Master as my input files… Now I want to check data from both files…
- If there in any change in data found in Dump File then that cell should be marked with Orange color
- If there is entire row found which is available in Dump but missing in Master then that entire row should marked in Green
- If entire row found missing in Dump but available in Master then that must be copy from Master to Dump at the last and highlight that entire row with RED color…
Check the output file attached herewith…
Output.xlsx (8.6 KB)
