Consulting

Results 1 to 5 of 5

Thread: Copy & Paste Dates with Macro

  1. #1
    VBAX Contributor
    Joined
    Apr 2010
    Posts
    182
    Location

    Copy & Paste Dates with Macro

    Hi anyone,

    I’m having a workbook where I'm trying to figure out a code that could copy the dates from column “F” of the sheet “Invoice” and paste them to each row that matches with the serial number in the column “A” of the sheet “Orders”.

    Any help on this would be kindly appreciated.

    I’ve attached the workbook for your reference.
    Best Regards,
    adamsm

  2. #2
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,844
    for others, see also your very similar thread http://www.mrexcel.com/forum/showthread.php?t=483609


    [vba]Sub blah()
    With Sheets("Orders").Range("A5:A3562")
    .FormulaR1C1 = "=VLOOKUP(RC[1],Invoice!R4C2:R1244C6,5,FALSE)"
    .Value = .Value
    End With
    End Sub
    [/vba]
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  3. #3
    VBAX Contributor
    Joined
    Apr 2010
    Posts
    182
    Location
    Thanks for the help p45cal. I do really appreciate it.
    Best Regards,
    adamsm

  4. #4
    Moderator VBAX Guru Simon Lloyd's Avatar
    Joined
    Sep 2005
    Location
    UK
    Posts
    3,003
    Location
    p45cal thanks for pointing out the crosspost.

    adamsm please read the explanation from Ken Puls (administrator here) which can be found in the crosspost link in my signature!
    Regards,
    Simon
    Please read this before cross posting!
    In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
    If I have seen further it is by standing on the shoulders of giants.
    Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)

  5. #5
    VBAX Contributor
    Joined
    Apr 2010
    Posts
    182
    Location
    Sure Simon. I'll read what you've suggested. Thanks for the response.
    Best Regards,
    adamsm

Posting Permissions

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