swdeveloper123
New Member
- Joined
- Mar 31, 2011
- Messages
- 1
Hi
I have two excel sheets which i need to compare the names and their profiles etc.I have written a macro to check and if the name in the respective column of the two sheets is same then it will print yes in the next column.
what i want is if that single row has more than 3 yes then copy that entire row to new sheet.Please help me and this is urgent.
I have two excel sheets which i need to compare the names and their profiles etc.I have written a macro to check and if the name in the respective column of the two sheets is same then it will print yes in the next column.
what i want is if that single row has more than 3 yes then copy that entire row to new sheet.Please help me and this is urgent.