Okay trying to figure out what I'm sure is quite simple but if I have the following code:
Sub Macro2()
Cells.Find(What:="Lubricant A", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Offset(0, 1).Copy Destination:=SheetCells.Find(What:="Lubricant A", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, SearchFormat:=False).Offset(0, 1)
End Sub
Now I want it to search for "Lubricant A" in the active sheet BUT look for and paste the value to "Lubricant A" into another sheet how can I do that? Because right now with the above code it will look for Lubricant A on the same sheet and obviously fail. Help? Thanks.
|