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:
The "What" is what needs to be changed somehow to whatever value is in the cell i select first then run the macro.
Thanks!
Bookmarks