Comparing 2 worksheets in Excel

Closed
husna - Updated on Aug 3, 2018 at 07:06 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 7, 2018 at 11:34 AM
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

Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Aug 7, 2018 at 11:34 AM
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