I have VBA that opens a file and copies data over based on name in column A. How would I update the statement to look at criteria in column A (Vxxxxxxx) and Column C (Axxxxxx)? I try to update but couldn't get the right combination.
Here is the part of the code with the if statement
For I = 2 To lastSourceCell.Row
If ws.Range("A" & I).Value = "Vxxxxxxx" Then
ws.Range("A" & I).EntireRow.Copy
ThisWorkbook.Sheets("ISS").Range("A" & destinationRow).PasteSpecial xlPasteAll
destinationRow = destinationRow + 1
If all of the VBA is needed, please let me know.