Macro to copy the same values between 2 sheets to a new one

Closed
hassameen Posts 1 Registration date Sunday February 2, 2014 Status Member Last seen February 2, 2014 - Feb 2, 2014 at 02:31 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 2, 2014 at 11:38 PM
Hello all,

I'm not very familiar with macros in Excel and I hope to find a solution. I need a macro that works with 5 sheets (sheet1,2,3,4 and 5) as following :

1 - compares between sheet1 and 2 .
2 - copy info from 2 thats not in 1 to sheet3.
2 - copy info from 1 thats not in 2 to sheet4.
3 - copy the similar from 1 and 2 to sheet5.
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Feb 2, 2014 at 11:38 PM
post small extract of workbook containing sheet1 and 2 through somthing like speedyshare.com.
0