I am new to Excel VBA and i really need some guidance.
I need to go row by row through "Sheet1" selecting one row at a time, check if the value in Column C is correct (value = selected), if it is, then copy the "selected" (Cell B) and (Cell E) that contains the word (selected)then copy - paste to "Sheet2" using MACRO
The result will be something like
Before
PPTED5QC PQC701 selected QCPC 10.143.20.209
PPTED5QC PQC702 selected QCPC 10.143.20.225
PPTED5QC PQC703 selected QCPC 10.143.20.241
PPTED5QC PQC704 selected QCPC 10.143.21.1
PPTED5QC PQC705 selected QCPC 10.143.21.17
After
PQC701
10.143.20.209
PQC702
10.143.20.225
Bookmarks