Processing Range/Array Data

I have data in one spreadsheet from D4 --> AE106. I am trying to set up an array for that data to be stored to, then in a looped logic statement verify that if certain conditions are met in particular columns of a row, the string in the first column gets "copy/pasted" into a list in another spreadsheet. I'm not familiar with VBA, but do have MATLAB experience. Unfortunately, I can't run MATLAB at work. Thank you in advance for any help that works!

Quote from Carim

Hello,

Your objective is not very clear ... but to get you started below is a "Read/Write" macro for your Array

Code

Public Sub ReadWriteArray()
    ' Declare dynamic array
    Dim MyArr As Variant

    ' Read values into Array from row 4 to 106
    MyArr = Range("D4:AE106").Value

    ' Write the values back to row 120
    Range("D120:AE222").Value = MyArr

End Sub

Display More

Hope this will help

Thanks that should help create the array to work with. I'm then trying to write a logic statement that if the conditions are met, the string value that is in the first column of each row gets written to a list in a separate workbook.

Quote from Carim

Hello,

Your comments do remain extremely vague ...

Why don't you create a sample file to illustrate precisely your objective

Maybe this will help, I've started with something like this, but not getting anywhere because I am not familiar with the VBA syntax/vernacular:

Sub FindNames()
For i = 1 to 103
If Gi and Mi and Ni and Oi and Pi = "C" then
Sheets(Sheet1).Range(Ai).Copy
Sheets(Sheet2).Range(Ai).Insert
End
End Sub