Comparing 2 worksheets in Excel

husna - Aug 3, 2018 at 04:47 AM - Latest reply: TrowaD 2438 Posts Sunday September 12, 2010Registration dateModeratorStatus October 16, 2018 Last seen
- 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

See more 

Your reply

1 reply

TrowaD 2438 Posts Sunday September 12, 2010Registration dateModeratorStatus October 16, 2018 Last seen - Aug 7, 2018 at 11:34 AM
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