Hey guys!
I have a list of 20,000+ items where i need to know what the size, color, and if/what pads they are. so lets do this:
When i run the macro it looks for text from a table (see attached) and puts the size in B and color in C and pads in D
Here is the tricky part:
In regards to color: it has to be whatever color appears first in the text string. There can be multiple color combos, but the first color is the primary color. So an example would be:
Enjoi Black/Red trucks = Black
Enjoi Red/Black trucks = Red
In regards to pads: most of the items arent pads so just leave it blank if there is an error (same goes for color and size as some items might not contain any.
I hope you can help me, and all help is greatly appreciated!
Bookmarks