Comparing 2 worksheets in Excel [Closed]

Report
-
Posts
2657
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 22, 2020
-
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

1 reply

Posts
2657
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 22, 2020
440
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