Is it possible to have a macro compare the contents in column "C" and were it finds a duplicate entry the macro would add to the first entry "-Free".
For example
CB1270 - Free
CB1270
In the above example the macro would add the "-Free" to CB1270.
The duplicate entries are next to each other.
Thank you
For example
CB1270 - Free
CB1270
In the above example the macro would add the "-Free" to CB1270.
The duplicate entries are next to each other.
Thank you