+ Reply to Thread
Results 1 to 9 of 9

Need macro to copy paste in empty cell.

  1. #1
    Forum Contributor
    Join Date
    06-01-2015
    Location
    Chennai,India
    MS-Off Ver
    Microsoft Office 2021
    Posts
    146

    Need macro to copy paste in empty cell.

    Hi all,

    I need a macro to copy paste a data to a empy cell.

    Eg. If a column D contains with date format then i need to copy the data from K to N and paste in E to H. Have provided the snapshotCapture.PNG

  2. #2
    Forum Contributor
    Join Date
    06-01-2015
    Location
    Chennai,India
    MS-Off Ver
    Microsoft Office 2021
    Posts
    146

    Re: Need macro to copy paste in empty cell.

    any is here to help me out...

  3. #3
    Forum Contributor
    Join Date
    06-01-2015
    Location
    Chennai,India
    MS-Off Ver
    Microsoft Office 2021
    Posts
    146

    Re: Need macro to copy paste in empty cell.

    I am struggling for this for past few month.. Need your help to sort it out....

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Need macro to copy paste in empty cell.

    Can you attach a sample file? I can't open .png file.

  5. #5
    Forum Contributor
    Join Date
    06-01-2015
    Location
    Chennai,India
    MS-Off Ver
    Microsoft Office 2021
    Posts
    146

    Re: Need macro to copy paste in empty cell.

    Hi John,

    I am unable to attach a file in this forum since it is been disabled in my browser... Can u tell me any other alternative way... plss

  6. #6
    Forum Contributor
    Join Date
    06-01-2015
    Location
    Chennai,India
    MS-Off Ver
    Microsoft Office 2021
    Posts
    146
    [QUOTE=Revathi kannan;4405571]Hi John,

    Please look into this attachement.. Have tried this from my mobile.
    Attached Files Attached Files

  7. #7
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Need macro to copy paste in empty cell.

    Maybe:

    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    06-01-2015
    Location
    Chennai,India
    MS-Off Ver
    Microsoft Office 2021
    Posts
    146

    Re: Need macro to copy paste in empty cell.

    It works great in the same way which i expected.

  9. #9
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Need macro to copy paste in empty cell.

    Glad to hear it works for you, and thanks for the feedback and the reps. Per Forum Rules please mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to copy and paste data to next empty cell.
    By Shellybelly in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-16-2015, 10:41 AM
  2. [SOLVED] Debugging macro to copy and paste cells if not empty
    By unaragazza in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-18-2014, 11:04 PM
  3. [SOLVED] Macro to Copy Range and Paste in the Empty Row Same Sheet
    By kaurka in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-22-2013, 11:01 AM
  4. [SOLVED] Macro to Copy cells data and paste on next empty row
    By tfaridi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-14-2012, 05:35 PM
  5. Macro to copy and paste to an empty cell
    By arodiaz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2011, 07:08 AM
  6. Help on copy and paste macro to next empty row
    By sarath25 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-09-2011, 05:26 AM
  7. Macro-Copy&Paste Fixed Data Ranges Into Last Empty Cell of Specific Column
    By hailnorm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2009, 10:15 PM

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