Hi all,
I'm very new to VBA and would hugely appreciate any help to figure out this issue. Attached is an example of my data, in which I would like to create a VBA script that looks at column D, and replicates that row for each comma separated piece of text in that cell.
For example, since Row 2, column D displays "707, All Users", I would like this row to appear twice with the unique comma separated text in each row. Hope that makes sense!
Sorry dont have time at the mo, but use SPLIT(text,separator) so split(range("d1").value,",") This will pass the broken up details to an array, then you can use UBOUND to find out how many rows to add.
this will split it then look at row inserting on google.
I am off home now, so cant offer any more advise, should be a good place to start
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
This should do...
Please Login or Register to view this content.
Thank you both, and this is exactly the solution I was looking for Jindon! Much appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks