Quote:
Originally Posted by excelledsoftware
Ok just give me a little time. I've got some family events tonight and then 1 thing to do tomorrow but it should not be too hard to write this out.
I will write a script that will go through all workbooks in a folder (You can specify the folder.) Then it will go through columns C and D and remove all carriage returns. (The starting row may be different for each workbook) The returns will be changed into a comma. Each of these workbooks will be saved with the same book name and left in the folder.) I should be able to have it done before the end of the week.
Thanks
|
That's fantastic! (I amusing that word a lot with your coding skills).
That sounds exactly right.
Caveat: The only moving variable is where the header names begin: "Items" and "No." don't always start on the 9th row, it can vary. But the columns C and D are constant. Does it matter in your code what number ROW it starts on, or does it just look for the names of the columns, starts from there and goes down the column, etc.?