not sure how to do this macro, hopefully not very complicated but don't know how to do it - so i would like to have this:
- if in Q5 is word LAY to delete cell T5
- if in Q6 is word LAY to delete cell T6
- if in Q7 is word LAY to delete cell T7
- if in Q8 is word LAY to delete cell T8
- if in Q9 is word LAY to delete cell T9
- if in Q10 is word LAY to delete cell T10
- if in Q11 is word LAY to delete cell T11
- if in Q12 is word LAY to delete cell T12
- if in Q13 is word LAY to delete cell T13
- if in Q14 is word LAY to delete cell T14
- if in Q15 is word LAY to delete cell T15
- if in Q16 is word LAY to delete cell T16
- if in Q17 is word LAY to delete cell T17
- if in Q18 is word LAY to delete cell T18
- if in Q19 is word LAY to delete cell T19
- if in Q20 is word LAY to delete cell T20
tnx for helping!
- if in Q5 is word LAY to delete cell T5
- if in Q6 is word LAY to delete cell T6
- if in Q7 is word LAY to delete cell T7
- if in Q8 is word LAY to delete cell T8
- if in Q9 is word LAY to delete cell T9
- if in Q10 is word LAY to delete cell T10
- if in Q11 is word LAY to delete cell T11
- if in Q12 is word LAY to delete cell T12
- if in Q13 is word LAY to delete cell T13
- if in Q14 is word LAY to delete cell T14
- if in Q15 is word LAY to delete cell T15
- if in Q16 is word LAY to delete cell T16
- if in Q17 is word LAY to delete cell T17
- if in Q18 is word LAY to delete cell T18
- if in Q19 is word LAY to delete cell T19
- if in Q20 is word LAY to delete cell T20
tnx for helping!