Originally Posted by That One Guy
Sorry, it's late and my brain is half ready to nod off. If I understand correctly, you're expecting to be able to get the names broken into the appropriate columns?
If so, what I would do is make a 4 page excel. Make the front page your end product then put each company on its own tab. As long as you have the columns set up right, this will allow you to copy different columns from each sheet and combine them. Getting the names broken up would be the hard part. After that, you can automate it by just recording a macro and there'd be nothing to write.
Sorry if I'm not getting where you're at but it seems like you should be on the homestretch if you got the names to break up properly.
Thanks, Bud. I'll try that and see how it works.