Macro to copy row data into new worksheets and separate delimited data

Let me start by saying i'm a novice when it comes to excel and I have spent alot of time searching for a solution to my problem, and I've found some great macro examples that do part of what I need, but not all.

I have attached a spreadsheet that shows what i'm trying to do.

On the first sheet (Sheet1) I have a few rows of data. I want to run a macro that will take each row and create a new worksheet (with the column A data as the name of the worksheet) for it following the template I have included. That much I was able to do with a macro I found and adapted. However, the second part is working with the street column that includes multiple data values seperated by ";#". What I want to do, after i've created each worksheet is go through that column and separate out each value delimited by ;# into a new column, as i've shown in the template example.

I couldn't find a way to do the seperation of data values after separating out each row into a new worksheet. If anyone could provide a macro that would meet both of these needs I would greatly appreciate.

Thanks in advance for your help!

Hey Leith -

Thanks for the warm welcome .

Here is an example of the delimited data:

Column A

data1;#data2;#data3;#data4

I wanted to break each value onto a separate row, and delete the ";#" symbols if possible.

Sorry for not including that in the sample, and thanks for your help!

I just realized looking at the sample I provided, that is didn't save the latest changes I made. The template is wrong as well. Here is the correct sample data file. Sorry about the confusion.

Here is the macro I found for replicating each row of data into a new worksheet. I was using this for a spreadsheet with more columns, but the principles should be the same:

Please Login or Register  to view this content.

Thanks so much for your help with this.

Refreshing this request in the hopes someone will have a way to update my existing macro. Hope everyone is having a great Christmas!