Comparing 2 worksheets in Excel

-
Hello,

I wanted to compare 2 worksheet. If there is a different it return the as below

Sheet 1: Apple vs Sheet2:Orange

and if no different it will call the original data

Sheet 1: Apple vs Sheet2:Apple

Need expert advise. Thanks

See more 

Your reply

1 reply

Posts
2440
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 13, 2018
0
Thank you
Hi Husna,

Could you explain in greater detail?

Is Apple the sheet name or a value on Sheet1?

Could you give some sample data of how it is now AND how you would like it to be?

Best regards,
Trowa
Respond to TrowaD