Results 1 to 11 of 11

Find, copy, and paste marco

Threaded View

  1. #1
    Registered User
    Join Date
    06-08-2011
    Location
    Portland, OR
    MS-Off Ver
    Excel 2007
    Posts
    20

    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.
    Last edited by OreEle; 07-29-2011 at 05:56 PM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1