Delete data excel?

Help Activities
, ,
1

I have file report column No , Status as below.

image

  1. I want to map column No from file report that status = Cut with File input sheet Summary.

  2. If found No. in file Input Sheet Summary → Delete Column A-I (in row No that = Cut)
    and delete row in sheet that in column Period (C_Apr , C_May)

    image
    image826×654 28.4 KB

  3. Copy data from sheet C_Apr , C_May that delete to new sheet Error.

Report.xlsx (9.8 KB)
input.xlsx (45.6 KB)
Output_Final.xlsx (43.3 KB)

Please guide me about it.

  • Remark Real Data have 5K rows.
2

@supermanPunch Can you guide me about this case?