Quote:
Originally Posted by excelledsoftware
The code takes the carriage returns out of the headers before it processes the columns. Now if header has other data in it besides No. or Item then yes that would need to be changed. At this point it would be best if you would post a sample sheet so I can write what is needed to that.
|
Here you go: a cleaned up template I inherited for work.
Download Template Here
As you can see (from the Excel file, once you open it) row 9, column 2 and 3, their headers have a carriage return on them. Again, thank you very much for helping like this.