Find contents then paste Column

[EJensen]

My Objective is to look for the text G62 in Column G. If Column G has text G62 anywhere in the cell and the same row of Column W has data I’d like to copy that row of Column W and paste its contents into the same row of Column Z. The problem I am having is when I run my macro it does not produce the desired result nor do I receive an error message to indicate anything is wrong (the text G62 does exist in Column G and Column W has data). If you can help me solve my problem, thank you.

Please Login or Register  to view this content.

[mdbct]

This line is looking for a text entry that starts with G62 and end with "

Please Login or Register  to view this content.

Valid entries would be
G62 SOME DATA "
G62"
G62 BLAH "

INVALID ENTRIES
G62
g62
DATA G62

If you want to check for G62 anywhere in the cells use:

Please Login or Register  to view this content.

I would also suggest not using COLUMN and ROW as variable names since they are properties within VBA. It won't necessarily hurt anything, but it can become confusing when debugging.

[EJensen]

It works well now! Thank you for explaning things to me, I appreciate the help.