Macro will not select new text to search for when run

Hello,

I hate to have my first post on a forum be crying for help, but to be honest I know NOTHING about macros so here goes.

I want to copy a selected cell, search another page for that value/string, when found, copy the cell to its right, then paste that value/string to the right of the originally selected cell.

The problem I am getting is the code is telling Excel to search for "text" which is fine, but when i run the macro from another cell, it keeps that "text" from the previous and searches for that. Here is my code:

Please Login or Register  to view this content.

The "What" is what needs to be changed somehow to whatever value is in the cell i select first then run the macro.

Thanks!

Oh I love you kind sir, that did it!!

here is another question:

Can I make this repeat (loop) down an entire column? I have about 300 + of these to do and hate clicking a cell each time then running the macro.

Thanks!

A very simple loop:

Please Login or Register  to view this content.

Or if you know exactly where the end of your data is you could use a proper loop (FOR NEXT, etc) which is much better programming practice than using GOTO commands but then I'm a lazy programmer.