VBA - One line of code not working

Hello

I have an Excel sheet with "Data" in a tabular format (see attached).
The tasks are to:
1. Read along Row1 to find Roles and Organisations (R&O) and tabulate these in a new sheet called "(2) Connections". COMPLETED
2. Read each following row to find a Connection between the RecordID (1-20 but could be more) and tabulate where there is a Connection. COMPLETED
3. Continue to read Frequency of each Connection (Daily, 2-3 times per week, etc)= COMPLETED

This all works well with the following SubRoutine.

What does NOT WORK is reading the final two sections - those being "Formal" and "Informal". (Line of code highlighted in the Subroutine).

The result should look like the file Solution1.png.

HOWEVER, I am generating the incorrect data in Columns 5 and 6.

ANY help would be appreciated.

==============. SUBROUTINE. =============

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hardly an error reading data. You're just putting the same data in elements 5 and 6 as you put in elements 3 and 4.

I might be missing something ...

NellyGrice,

Re your PM;
Try change
1)

Please Login or Register  to view this content.

2) newly added line to

Please Login or Register  to view this content.

If this is not how you want, need clear explanation for data in new columns, E & F.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.