+ Reply to Thread
Results 1 to 10 of 10

Macro to copy and paste without overwriting existing data

  1. 01-15-2016, 09:04 AM #1
    jmack36
    jmack36 is offline
    Registered User
    Join Date
    01-15-2016
    Location
    Jupiter, FL
    MS-Off Ver
    2010
    Posts
    5

    Macro to copy and paste without overwriting existing data

    What I have is a report that we update daily. New lines are inserted in the existing worksheet daily. Column H is the desired due date and column J is expected completion date (which is manually updated by project managers). What I would like to do is have a macro that will copy column H and paste to Column J (making the completion date equal to desired due date, but not overwrite cells in Column J that already have expected completion date.

    sample
    H J
    1/01/16 1/15/16
    1/01/16
    1/01/16 1/16/16
    1/01/16 1/08/16
    1/01/16

    desired output
    H J
    1/01/16 1/15/16
    1/01/16 1/01/16
    1/01/16 1/16/16
    1/01/16 1/08/16
    1/01/16 1/01/16
    Reply With QuoteRegister To Reply
  2. 01-15-2016, 09:14 AM #2
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Macro to copy and paste without overwriting existing data

    Hi jmack
    Suppose your dates are in row 1
    try this code
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
  3. 01-15-2016, 09:30 AM #3
    MickG
    MickG is offline
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Macro to copy and paste without overwriting existing data

    Try this:-
    Please Login or Register  to view this content.
    Regards Mick
    Reply With QuoteRegister To Reply
  4. 01-15-2016, 10:48 AM #4
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Macro to copy and paste without overwriting existing data

    Thanks Mr. Mick for this nice code
    But your results are fixed at all the blank cells in column J .. it is supoosed to be equal to the value in column H in the same row
    I think it should be like that
    Please Login or Register  to view this content.
    Last edited by YasserKhalil; 01-15-2016 at 10:53 AM.
    Reply With QuoteRegister To Reply
  5. 01-15-2016, 12:22 PM #5
    MickG
    MickG is offline
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Macro to copy and paste without overwriting existing data

    It idea looked good on Paper , pity I overlooked the results !!!!!
    Reply With QuoteRegister To Reply
  6. 01-15-2016, 12:44 PM #6
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Macro to copy and paste without overwriting existing data

    Quote Originally Posted by MickG View Post
    It idea looked good on Paper , pity I overlooked the results !!!!!
    Yes you are right. It looks very good and I'm surprised why it didn't bring correct results ..?
    Reply With QuoteRegister To Reply
  7. 01-15-2016, 12:59 PM #7
    jmack36
    jmack36 is offline
    Registered User
    Join Date
    01-15-2016
    Location
    Jupiter, FL
    MS-Off Ver
    2010
    Posts
    5

    Re: Macro to copy and paste without overwriting existing data

    Thanks to everyone for the quick replies. The code by YasserKhalil worked perfectly, thanks!
    Reply With QuoteRegister To Reply
  8. 01-15-2016, 01:18 PM #8
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Macro to copy and paste without overwriting existing data

    You're welcome
    Thanks for the feedback
    And many thanks for Mick for his nice and great code that I make use of it to achieve the task
    Regards
    Reply With QuoteRegister To Reply
  9. 01-16-2016, 06:47 PM #9
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Macro to copy and paste without overwriting existing data

    This is my try to do the task without looping
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  10. 01-18-2016, 07:49 AM #10
    MickG
    MickG is offline
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Macro to copy and paste without overwriting existing data

    YasserKhalil , Nice code !!!!

    Slight addition, Perhaps:-
    Please Login or Register  to view this content.
    Last edited by MickG; 01-18-2016 at 07:56 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data Validation - Avoid overwriting due to copy/paste
    By amitgaja007 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-18-2015, 01:29 AM
  2. Copy data without overwriting existing data
    By pcdots in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-26-2014, 01:01 PM
  3. Create macro to copy-n-paste all data from an existing worksheet to another existing works
    By jdunbarjr in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-04-2013, 04:32 PM
  4. Create macro to copy-n-paste all data from an existing worksheet to another existing works
    By jdunbarjr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-14-2013, 03:06 PM
  5. Stop overwriting cells - Copy and paste macro
    By juhaszp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2013, 05:37 PM
  6. Macro to copy and paste data into database
    By kayoke in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2012, 05:00 AM
  7. Macro to update database without overwriting existing data
    By kayoke in forum Excel General
    Replies: 2
    Last Post: 06-11-2012, 05:36 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1