I'm very new to VBA and just trying to build a very basic tool but I am a little stuck so hoping someone can help!

I have setup as in the image below

I'd like to take the string in column B and compress it so that at the click of a button (pre-created) I create a list which contains only the string that varies i.e. Apple, Apple 1, Banana and Banana 2. This list needs to present in the Codes tab where the user can assign an integer to each (1 and 2).

Once the codes are assigned the user would click the button and the codes would appear in a third tab (Results) with the itemised number and code next to it.

I hope this makes sense. I'm really not sure where to start with this!

Thanks in advance!

I've attempted various things I've found on the internet to compress the list but couldn't get the code to compile.

Please see screenshots of how the tabs will be set out below: