Good evening everyone,
I have difficulty figuring out the following problem.

I have two sheets. One called “Matrix” and the other “Factors”.

My Matrix sheet will be for information only. All of the columns are complete.

I have 6 section always in column X.
One in row 18 to 27
One in row 29 to 38
One in row 40 to 49
One in row 51 to 60
One in row 62 to 71
One in row 73 to 82.

In my Factors sheet I have 6 section and some selection, Always in Column D.
One in row 14 to 42
One in row 46 to 64
One in row 68 to 93
One in row 97 to 127
One in row 131 to 155
One in row 159 to 167

I also have set up a validation list for yes or no in column C in these range of selection.
If I select yes in column C vs a selection in the “Factors” sheet, I need it to copy the information from that selected row column D to my “Matrix” sheet in the range on the next available row.
Example:
Factors sheet row 14 to 42 equals to the Matrix sheet row 18 to 27. So if I select yes in row 20 column C then it will copy and paste the information in the first available row in the Matrix sheet between row 18 to 27.

If there is already information in my row 18, then copy the information in the next available row therefore 19… Always in Column X.

But I need to have the range match the same range from the two sheet

Therefore the “Factors” sheet needs to match with the following row in the “Matrix” sheet:

row 14 to 42 in Factors match row 18 to 27 in Matrix
row 46 to 64 in Factors match row 29 to 38 in Matrix
row 68 to 93 in Factors match row 40 to 49 in Matrix
row 97 to 127 in Factors match row 51 to 60 in Matrix
row 131 to 155 in Factors match row 62 to 71 in Matrix
row 159 to 167 in Factors match row 73 to 82 in Matrix

I have some codes that I’m using for another workbook but I’m lost I have the “if yes” selection vb code but I don’t know even where to begin…

Please Help