For example,
An excel file with
A1
=======
Apple
Banana
Kiwi
Watermelon
I need the vba script to loop through the A1 column, and if a specific text does not exist, it will add the text to the very bottom of the column.
so for example, if i wanted to add peach, the result would be
A1
=======
Apple
Banana
Kiwi
Watermelon
Peach
since peach does not exist in A1. Also, if let's say I wanted to add "apple" but "apple" already exists, I would like to add text to the column beside it saying "already exists."
A1 B1
=======
Apple Already exists.
Banana
Kiwi
Watermelon
how can i do this using vba?
Any help would be appreciated.
Thanks.
An excel file with
A1
=======
Apple
Banana
Kiwi
Watermelon
I need the vba script to loop through the A1 column, and if a specific text does not exist, it will add the text to the very bottom of the column.
so for example, if i wanted to add peach, the result would be
A1
=======
Apple
Banana
Kiwi
Watermelon
Peach
since peach does not exist in A1. Also, if let's say I wanted to add "apple" but "apple" already exists, I would like to add text to the column beside it saying "already exists."
A1 B1
=======
Apple Already exists.
Banana
Kiwi
Watermelon
how can i do this using vba?
Any help would be appreciated.
Thanks.