Lop 1 lop 2 lop 3 lop 4 av 2 av 4 av 5
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0
1 0 0 1 0 1 0

i have the table, i want to find in row 1, all cells have "lop" then copy ebtire column and paste to another sheet.
Pls help me to solve. Like this

lop 1 lop 2 lop 3 lop 4
1 0 0 1
1 0 0 1
1 0 0 1
1 0 0 1
1 0 0 1
1 0 0 1
1 0 0 1
1 0 0 1
1 0 0 1
1 0 0 1
1 0 0 1
1 0 0 1