Search and assign by criteria and create new content with custom pattern

[pomper]

Hello

I have reference numbers list that is assigned to different categories and subcategories. Number "1" links ref # to its categories and subcategories as you can see on attached image.
How to write VBA code that assignes different categories and subcategories to its ref # according to the following pattern below with slash and comma:

ref #	ee2233
categories	main-category/subcategory,main-category-y/sub-category-y

Please Login or Register  to view this content.

1z4h8xf.jpg

[jindon]

Delete Row 1:2 in Sheet1 then run the code

Please Login or Register  to view this content.