mercredi 21 juin 2017

Checking a column for specific text

I have been looking everywhere but I cant figure this one out.

I need a VBA code that looks at the cells within a column (about 100 lines within column b) and checks to see if those cells are blank or if they say True, if one doesn't then I need it to copy the text in that cell and paste it on sheet2. It would be great if it could reference the line where the wrong text is on.

If someone can figure this out that would be awesome, thanks

Aucun commentaire:

Enregistrer un commentaire