I need some assistance with modifying some VBA code.
As a picture is worth a thousand words, please see the attached XLS first. Here's some additional background.
1. Columns C (and B) use a carriage return within a cell
2. I need to split the content of columns C and B into separate rows and then duplicate the content of columns A and D for each newly created row.
The attached XLS successfully splits content of column C (and add content of colums A and D) into subsequent rows. However, the routine does NOT perform the cleanup process for column B also.
I have tried to modify the "Range" statement but doesn't seem to work for me. I also created a 2nd ForLoop but that creates now too many records (based on content of column C, I have 7 records).
My question: How can I modify the VBA routine so that both columns B and C are split?
Thanks in advance,
P.S. When running the VBA code, the original "Sheet1" is renamed and the newly created sheet is called "Sheet1".