N
nancy
I believe this is possible but I am having difficult since
I am new to VB. I have a work sheet with column A TO F. I
will like a code that will search for the word "John" from
any of the column B TO F and move it to column A. The cell
in A to move this "john" will always be blank. It should
move it across the same row. Example.
A B C D E F
70 25 JOHN 5 10
5 JOHN 2 11 5
The macro should be able to move all john to column A.
Answer:
A B C D E F
JOHN 70 25 5 10
JOHN 5 2 11 5
Any help will be grateful.
I am new to VB. I have a work sheet with column A TO F. I
will like a code that will search for the word "John" from
any of the column B TO F and move it to column A. The cell
in A to move this "john" will always be blank. It should
move it across the same row. Example.
A B C D E F
70 25 JOHN 5 10
5 JOHN 2 11 5
The macro should be able to move all john to column A.
Answer:
A B C D E F
JOHN 70 25 5 10
JOHN 5 2 11 5
Any help will be grateful.