+ Reply to Thread
Results 1 to 3 of 3

Macro to Copy and Paste contents of one Cell depending on the lookup of another

  1. #1
    Registered User
    Join Date
    07-25-2009
    Location
    South London, England
    MS-Off Ver
    Excel 2007
    Posts
    8

    Macro to Copy and Paste contents of one Cell depending on the lookup of another

    Hello everyone,
    As my VBA skills only reach to looking and modifying recorded Macros, I'm pretty much stuck on this one.
    I have two sheets named Payments and Invoices. In a macro, I want to match the contents of Invoices cell P1 to where it occurs in Payments Column E then into the corresponding cell (row) in Column C of the Payments Sheet, copy and paste the contents of Invoices cell C43. Is this possible? If anyone could start me off I’d be most obliged.
    Regards
    Graham

  2. #2
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Re: Macro to Copy and Paste contents of one Cell depending on the lookup of another

    it is possible and should be quite easy. As I'm lazy tho, please attach a workbook and mark (with a color/comment or in any other way) what has to be done ^^
    If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.

  3. #3
    Registered User
    Join Date
    07-25-2009
    Location
    South London, England
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Macro to Copy and Paste contents of one Cell depending on the lookup of another

    Hi Bishonen
    As requested I attach a workbook named Payments2 which has 2 sheets, PAYMENTS and INVOICES. What I would like is a macro which will copy and paste the value of INVOICES!C43 into the cell in PAYMENTS! B:B which is on the same row as the unique match found in PAYMENTS!E:E and INVOICES!P1
    Thanks in advance
    Graham
    Attached Files Attached Files

+ Reply to Thread

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