Ok thanks for posting this.

The sheet has several tables. When you said headers one would assume you mean the first row but that appears to not be the case.

Now before I get into this over the weekend I need to know 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 thats all we need to do no problem I can have it written pretty quickly. If that is not all then I need another spreadsheet attached that has a good amount of data (not a blank template) and instructions of what you want.

Use the attachment button on this form and attach a workbook with the needed info if necessary.

Let me know and I will get started on it.

Thanks

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")

Attached Files

123 456 007 Z 001 A Part Name Attribute Name.xlsm (28.9 KB, 13 views)