+ Reply to Thread
Results 1 to 15 of 15

Copy and Paste Cells to Next empty cell in range

  1. #1
    Registered User
    Join Date
    07-10-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2007
    Posts
    25

    Copy and Paste Cells to Next empty cell in range

    Hello, hope this is a simple problem to solve:

    I have data in cells J7:J11.

    I would like to copy and paste this data into the next empty cell in the range E7:I11

    easy way to do this?

    Thanks

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy and Paste Cells to Next empty cell in range

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-10-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Copy and Paste Cells to Next empty cell in range

    Hi where do i enter this?

  4. #4
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010
    Posts
    698

    Re: Copy and Paste Cells to Next empty cell in range

    Oddin,

    You trying this using thru Formula ?? or VBA ??

    Regards
    Keep the Forum clean :


    1. Use [ code ] code tags [ /code ]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. Show appreciation to those who have helped you by clicking * Add Reputation below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  5. #5
    Registered User
    Join Date
    07-10-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Copy and Paste Cells to Next empty cell in range

    I would need to use VBA to copy J7:J11 and then paste it in the first empty cell in the E7:i11 range I believe

  6. #6
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010
    Posts
    698

    Re: Copy and Paste Cells to Next empty cell in range

    try this

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    07-10-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Copy and Paste Cells to Next empty cell in range

    thanks but how does this determine where the first empty cell in the e7:i12 range?

  8. #8
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy and Paste Cells to Next empty cell in range

    This will put the copy range in to next empty cell in column E

    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    07-10-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Copy and Paste Cells to Next empty cell in range

    Thanks, maybe I should clarify. there is data above beside and below the range E7:I12. If I use this code then the data will be pasted below all of this and outside of the desired range.

    How can I code so that excel looks at cell e7 and if it is not blank then looks to F7 etc until it goes to I7

  10. #10
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy and Paste Cells to Next empty cell in range

    In that case, you need to set a loop.

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

    Re: Copy and Paste Cells to Next empty cell in range

    Maybe?

    Please Login or Register  to view this content.

  12. #12
    Registered User
    Join Date
    07-10-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Copy and Paste Cells to Next empty cell in range

    thanks so much - this worked! just a question - how can i enter the code for paste special instead of just paste in the line right before the END SUB

    Tks
    Mark

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

    Re: Copy and Paste Cells to Next empty cell in range

    Maybe:

    Please Login or Register  to view this content.

  14. #14
    Registered User
    Join Date
    07-10-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Copy and Paste Cells to Next empty cell in range

    thank you - that works perfectly!

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

    Re: Copy and Paste Cells to Next empty cell in range

    You're welcome. Glad to help out and thanks for the feedback and the rep. Don't forget to comply with Forum Rule No. 9.


    mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.

+ 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. how to copy a range of cells, paste them and then find next empty cell
    By comp23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2013, 03:34 PM
  2. Replies: 1
    Last Post: 04-22-2013, 10:34 AM
  3. Copy range from one workbook, paste to next empty cell in another workbook
    By glock9mm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2013, 12:16 AM
  4. VBA to copy selected cells down to empty cell and paste
    By rioutousgnome in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-28-2013, 01:55 PM
  5. Change range of cells within VBA macro and copy and paste to fixed cell range
    By Mannyny in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-20-2012, 11:51 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1