I have data in Column O that might read like this:
Colour: Red, Size: small, Wash: Hot, Material:Cotton, Code:412341, Chest:34, Batch:55
Material:Poly, Code:9999, Chest:34, Batch:12, Colour: Blue, Size: small, SYSTEM: tts
In AR, AS, AT, AU, I want to enter some headers and the macro will match the data to the headers (up to the , delimiter) then put everything else in BA & subsequent columns but delimited by ,
Colour / Material / Code / Batch Column BA onwards ( Everything else seperated into columns by comma delimiter )
Red Cotton 412341 55 Size: small / Wash: Hot / Chest:34
Blue Poly 9999 12 Chest:34 / Size: small / SYSTEM: tts
£30 via paypal to best result!
Thanks
Alan
Bookmarks