Find, copy, and paste marco

I'm trying to make an ELO calculator, but I don't know much about macros (other than the recording feature).

How can I take the contents from cell A4 (on sheet 1), search for it (exact search) on sheet 2, copy the contents of the cell 2 columns over of the search result, and paste those results in cell B2 (on sheet 1)?

When I try doing a record action for the macro, it doesn't copy the search result cell as such but just that cell (so if the result is A13 when I'm recording, it will always do A13, regardless of what search results it gets).

Any help would be greatly appreciated.

Hi OreEle, the following code finds the value from Sheets 1 A4, gathers the data from two columns over from the found cell, and then places it into sheets 1 B2, just as you asked. Let me know if you need more.

Please Login or Register  to view this content.

You are welcome!

Hi OreEle, as I said in my PM to you, you should start a new thread if the question is different, even if the project is the same.

Sorry OreEle, I guess your question still fits. For an answer, I don't know! I know that I have had issues with Excel's Find method giving results that were wrong because of the issues you point out (Dan, Daniel, etc). I will post this question to the gurus of this site and hopefully you get an answer soon.

There are several arguments to the Find method and it is rarely wise to only specify what to find, since the settings persist between searches and searches in the UI will affect code searches and vice versa. In addition to specifying what to find, you should specify LookAt:=xlWhole for a match on the entire cell, Lookin:=xlvalues or xlformulas as appropriate and you may wish to specify MatchCase:=true or false for case sensitivity.

Yes, yes, yes! Preach it, Romper!

Never use a FIND command without Lookin:= and LookAt:= at a minimum. Always always always!

Please Login or Register  to view this content.