Read, copy, paste

[jericho14444]

Hi, does anyone know the vba code to read the word "it" in column B, and once the code reads it, copy the cell to the right of it to another sheet?
Thank you

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.