Hi,
I wanted to create an macro application.
In 1st sheet, I have 5 columns and 1000 rows (may vary).
In 2nd sheet, I have 5 columns and 1000 rows (may vary).
Now I wanted to compare 1st sheet with 2nd sheet (Only one column)
If cells in sheet1 is not equal to sheet2, copy that entire row to new sheet3.
Please anyone help...