hello community

Is there a way for me to copy and paste data from " B" worksheet to " A "
worksheet but those with repeated data be omitted off ? Example:

" A " worksheet " B "
worksheet

A B C A
B C

1 Apple 1 Apple

2 Orange 2 Strawberry

3 Pineapple 3 Pineapple

4 4 Mango

from the above worksheets, I wanted to copy the fruits in " B " worksheet
and paste into " A " worksheet but if there is any fruits repeated, the data
will ignore.

thanks community for the help and hope my description and example is clear
to understand :)


--
oldLearner57