I have a 15,000 line sheet that has 20 or more columns of information. I would like an easier way to find Sizes and Color (flavor, etc) from the Title Column and DIsperse the text to the coordinating columns. Below is an example of a few rows of text I need to break down. Is there a vba code? This has taken me days! I am a beginner with VBA but I can learn. Thanks!!
Primetime Petz 360Degree Extension Kit With Door 30"
Primetime Petz 360 Configurable Gate with Door 36"
Prevue Pet Products Birdie Basics Wood Swing 3inX4in
Lixit Water Boy Travel Bottle with Bowl 3qt
Prevue Pet Products Birdie Basics Wood Ladder 3-Rung
Four Paws Super Absorbent Wee Wee Pads 40ct
Prevue Pet Products Birdie Basics Wood Swing 4inX5in
Caru Dog Natural Wild Boar Treats Bites 4oz.
Ethical Products Spot Lattice Balls With Bell 4pk
Ethical Products Spot Hot Dog With Squeaker 5in