Make duplicate lines if "B" Column Cell Values have more than one Comp Value, then Update Comp as per Records by line

[Guna13]

I am a newbie to VBA. I need to create multiple same line based on If The Condition of **“B”** column has Cell-Value more than one Company Values.

Insert one row below the active row, and paste the values of the recently copied cells into the new blank row. Then Update Comp Values by row.

I will appreciate being taught how to only copy certain cells of active rows to paste below. is it Doable in VBA Macro??? - Thank you.

Column "B" Value in below Format

1. PCBA_ISRAEL_400

2. PCBA_ISRAEL_400 PCBA_ISRAEL_400;#PCBA_ISRAEL_T_400

3. PCBA_ISRAEL_T_400

4. PCBA_ISRAEL_400;#PCBA_ISRAEL_T_400;#ISR_CORP_SERV_400;#DSN_ISRAEL_400

5. PCBA_ISRAEL_400;#PCBA_ISRAEL_T_400;#ISR_CORP_SERV_400;#DSN_ISRAEL_400

6. PCBA_ISRAEL_400