VBA Code to Split Row with Multiple values, inserts them with tables rows..

[Prinz Jaymes]

Seeking a VBA code that can 1. Split Row Cell tht has multiple values separated by "or"…. 2. Insert New rows from the Split Data…..3. New rowswith individual values must still contain column information across table
Prgram List Client SCHOLARSHIP OUTPUT
FNP_PROJECT_DEAN New Y,k PNG grp PJT_SCHOLARSHIP_NEW 25
PJT_END_KDS MTN Global PJT_SCHOLARSHIP_BNK 45
PJT_SCHOLARSHIP_NEW Proct, & Gamble FNP_PROJECT_DEAN 32
FNP_MNY_NEW Samsung R&D BRN_PJT_KNP or FNP_PROJECT_DEAN or PJT_SCHOLARSHIP_NEW 5

PJT_SCHOLARSHIP_BNK New Y,k PNG grp FNP_PROJECT_TM 65
For instance
FNP_PROJECT_DEAN has several values under Column "SCHOLARSHIP" .
I would like a VBA CODE that can split all 3 SCHOLARSHIPS and still maintain the "PROGRAM" list, CLIENT.
EXAMPLE:
FNP_MNY_NEW Samsung R&D BRN_PJT_KNP 5
FNP_MNY_NEW Samsung R&D FNP_PROJECT_DEAN 5
FNP_MNY_NEW Samsung R&D PJT_SCHOLARSHIP_NEW 5
Please note, It will be great to be able to expand this on the Actual Data Sheet , on new W,ksheet
NOTE, FIND AND REPLACE "OR"

 

[Hui]

Prinz

Can you please post a sample file with a sample set of data and what it should look like after the modification

Thanx

 

[Prinz Jaymes]

Hi Hui
I have attached the File as Requested. I outlined the issues I am having.
Hope this helps

 

[Hui]

Prinz

Have a look at the file attached
There is a Button next to the Table
press for a good time

 

[Prinz Jaymes]

Hui
You are a demi-God. Good job on that.

Also, the Split code seems to work only once. Can it be used multiple times?

More importantly, were you able to find a code to compare and contrast those unique values. See original file pls.

 

[Hui]

Prinz
The code stops at a blank cell, this is probably your issue