VBA to create new lines of data

[jmewebb]

Data separated by a comma in column "I" need to create a new row as shown under "Convert to:". The original data file already contains approximately 200k rows. I had another code but it took hours to run.

 

[Joe4]

BINGO!!! We have a winner! Finally got it to work. Thank you so very much for all of your expertise!

You are welcome.

So what ended up being the issue?
It is helpful for us to know, for future reference, so we know what kind of things can happen and what suggestions to make.

 

[jmewebb]

You are welcome.

So what ended up being the issue?
It is helpful for us to know, for future reference, so we know what kind of things can happen and what suggestions to make.

It was user error. I needed to move my data to Sheet1 and rename it. I'm sure there was a work around in the code but I don't know how to do that.

 

[Joe4]

It was user error. I needed to move my data to Sheet1 and rename it. I'm sure there was a work around in the code but I don't know how to do that.

You could simply just change the name of the sheet in the code in the line that assigns the sheet name to "ws1".

    Set ws1 = Sheets("Sheet1")

If you change "Sheet1" there to whatever the name of your sheet is, it will filter done to the rest of the code (since we are using Worksheet objects).