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:
' test Macro
' Keyboard Shortcut: Ctrl+q
Cells.Find(What:="10:00:00:00:C9:39:49:FC", After:=ActiveCell, LookIn:= _
xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Activate
Application.CutCopyMode = False
The "What" is what needs to be changed somehow to whatever value is in the cell i select first then run the