Hello Forum,
I'm trying to write a conditional macro where VBA will add (x) number of rows depending on how many separate numbers appear in a specific cell. However, I just discovered VBA and I can't find any postings that specifically address this scenario. I don't know if it can be done with a formula - I figured only VBA could add rows dynamically. I've included a generic and fictional example below of how the data appears and how it needs to look like. I am using Excel 2010.
Important Note: Ideally, all of the customer data that appears in columns A - L and N - onward should all replicate on the rows that are created beneath the first row. Also, all of the account number values will be delimited by a comma that separates them and some of them will vary slightly in length.
CURRENT FORM:
<tbody>
</tbody>
DESIRED FORM:
<tbody>
</tbody>
I have no idea if this can be done but I would be eternally grateful if so
Thank you in advance for your help!
~Eric
I'm trying to write a conditional macro where VBA will add (x) number of rows depending on how many separate numbers appear in a specific cell. However, I just discovered VBA and I can't find any postings that specifically address this scenario. I don't know if it can be done with a formula - I figured only VBA could add rows dynamically. I've included a generic and fictional example below of how the data appears and how it needs to look like. I am using Excel 2010.
Important Note: Ideally, all of the customer data that appears in columns A - L and N - onward should all replicate on the rows that are created beneath the first row. Also, all of the account number values will be delimited by a comma that separates them and some of them will vary slightly in length.
CURRENT FORM:
Column A | .... | .... | Column M |
Customer_Name | Account_Number | ||
Customer 1 | 1111111111,2222222222,333333333,44444444444,5555555555,6666666666,7777777777 |
<tbody>
</tbody>
DESIRED FORM:
Column A | .... | .... | Column M |
Customer_Name | Account_Number | ||
Customer 1 | 1111111111 | ||
Customer 1 | 2222222222 | ||
Customer 1 | 333333333 | ||
Customer 1 | 44444444444 | ||
Customer 1 | 5555555555 | ||
Customer 1 | 6666666666 | ||
Customer 1 | 7777777777 |
<tbody>
</tbody>
I have no idea if this can be done but I would be eternally grateful if so
Thank you in advance for your help!
~Eric