I want to compare data in two sheets

Closed
Viji - Oct 21, 2011 at 09:33 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 24, 2011 at 09:57 AM
Hello,
I am stuck up with a problem in macro please do help me,
I have 2 sheets with data i want compare two sheets, if the data is same it should copy the same in third sheet else copy the unmatched data in sheet4. Please do reply for this post...

I hope to get reply from you guys....

thanks in advance

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Oct 24, 2011 at 09:57 AM
Hi Viji,

What do you want to compare? Cells, rows, columns?

Please provide more details.

Probably the best way to provide more details is to upload (a sample of) your file using a filesharing site like www.speedyshare.com. Make sure your file extention is .xls, because I'm still using Excel 2003.

Best regards,
Trowa
0