mercredi 15 janvier 2020

If .Range("B4:F4") contains ("N") then copy ("A4")

I'm new to VBA and I'm really just not sure how to translate this to that language. Basically, at my office, we have an audit system. If something is up to code we mark it as C (conforming) if it's not we mark it as N (non-conforming). I'm trying to copy the Questions (column A) that have an N. Range ("B4:F4") are for five separate weeks. So one question has the opportunity to be right or wrong five times. All I need is one (or more) "N" for the question to be copied. I hope I did a good job describing my issue. Any help is appreciated.

''' If .Range("B4:F4") contains ("N") then copy ("A4") '''

Aucun commentaire:

Enregistrer un commentaire