Quote:
Originally Posted by excelledsoftware
Ok thanks for posting this.
if all you are trying to do is identify the 2 columns that have Items Sheet, and no. items and then replace the carriage return with a comma. If that's all we need to do no problem I can have it written pretty quickly.
|
File attached.
Yes. That's basically all I am trying to do. But after you got the code to run, I noticed the headers actually had a carraige return too, and I had to manually going into the headers and remove the carriages before the code could work. That was my oversight. Sorry about that.
Don't work on the weekend for this; I would feel bad. You've done heroic work, man. Thank you very much again for your time and effort.
Related question: Is there a way to open all the Excel files into Excel into one window, and run a batch on them with your code? Oh, BTW. That's the naming convention for all the files: numbers, then part name, and then attribute (e.g, "left" part, or "right", "back" or "front")