Automatically create new rows based on a delimited string in one cell?
Hi.
I have a large spreadsheet of product data where one column contains the variations of each product as a delimited string.
I need a separate row for each of the variations so how do I automatically create additional rows under the original and then have the delimited string spread across those rows, like this: -
Attachment 599340
Thanks :-)
See if this works for you
Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Thanks for your help JLGWhiz.
I'm confident to add the VBA but I don't understand the code so I need a little help to modify it for my spreadsheet if you can help? The column with the delimited text is K and the product variations can be from 2 to 10 in quantity (not sure if this matters). The spreadsheet has column headers. Thanks ;-)
It really helps if you give an accurate layout of your data by columns and rows in the original post. See if this will work for you.Originally Posted by Thintin
If you have data past column K, it will not fill down as columns A-J does. Copy the code to your standard code module1.Please Login or Register to view this content.
Thanks for the reps. If Post #4 closed the issue, the you should mark the thread as solved.
Regards, JLG
Happy new year!
I put this part of my project on hold while I sorted out some more pressing issues but I'm back on it now.
When I run this code I get a 'compile error: Variable not defined' at the first mention of 'c' (see screenshot)
VBA compile error.jpg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks