+ Reply to Thread
Results 1 to 3 of 3

copy range and paste values only to another sheet in next empty row

  1. 01-21-2015, 08:43 PM #1
    KK1234
    KK1234 is offline
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    copy range and paste values only to another sheet in next empty row

    Hi all,
    following is the code I am trying to modify.

    Please Login or Register  to view this content.
    What I am trying is that from sheet1, in selected row , copy range A:J and paste in sheet2 in next empty row values only in same range A:J
    Something is wrong and can not figure it out.
    Any help please
    Kind regs
    Reply With QuoteRegister To Reply
  2. 01-21-2015, 09:14 PM #2
    WasWodge
    WasWodge is offline
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    883

    Re: copy range and paste values only to another sheet in next empty row

    One way possibly.

    Please Login or Register  to view this content.
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
    Reply With QuoteRegister To Reply
  3. 01-22-2015, 05:08 AM #3
    KK1234
    KK1234 is offline
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    Re: copy range and paste values only to another sheet in next empty row

    Hi WasWodge,
    It worked well.
    Great solution indeed.
    Thanks
    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. [SOLVED] Copy and paste values in column range into first empty column to the left
    By gbatz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-15-2014, 06:59 PM
  2. Macro code to copy range of cells, paste special on p/word protected sheet and hide empty
    By TheBigMT in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2014, 11:51 AM
  3. [SOLVED] Copy and paste range as values to specific sheet/range
    By lukestkd in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-06-2014, 09:48 PM
  4. [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
  5. Macro to Copy Range with Merged Cells and Paste in the Empty Row in the Same Sheet
    By kaurka in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2013, 10:34 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