+ Reply to Thread
Results 1 to 4 of 4

Copy cells with data - paste (insert rows) to next sheet.

  1. #1
    Forum Contributor
    Join Date
    01-06-2012
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    165

    Copy cells with data - paste (insert rows) to next sheet.

    Hi,

    I have the following macro which will copy populated rows in sheet 'MLS' and paste them in the first empty row after A20 in 'SalesDB'.

    However, rather than just paste the values, I'd like it to insert the rows at the first empty cell after A20.

    Can anyone offer any advice what to modify in order to achieve this?

    Please Login or Register  to view this content.
    Many thanks

  2. #2
    Valued Forum Contributor
    Join Date
    08-07-2014
    Location
    Quito, Ecuador
    MS-Off Ver
    Excel 2016 & 365, Windows 10
    Posts
    511

    Re: Copy cells with data - paste (insert rows) to next sheet.

    @ BPSJACK
    Check if this little change works for you:

    Please Login or Register  to view this content.
    Barriers are there for those who don't want to dream

  3. #3
    Forum Contributor
    Join Date
    01-06-2012
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    165

    Re: Copy cells with data - paste (insert rows) to next sheet.

    Thanks for the reply.

    However that code gives me the error "This won't work because it would move cells in a table on your worksheet".

  4. #4
    Valued Forum Contributor
    Join Date
    08-07-2014
    Location
    Quito, Ecuador
    MS-Off Ver
    Excel 2016 & 365, Windows 10
    Posts
    511

    Re: Copy cells with data - paste (insert rows) to next sheet.

    Perhaps you have your data formatted as a table, in the target wsht.
    ( Tables have some weird behavior sometimes, !! I do prefer plain data )
    Just to understand, can you try over a non formatted data?
    I've tested the code, and worked nicely.

+ 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. [SOLVED] insert sheets 2 & 3 and copy & paste data from the first sheet
    By RobinPrice in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-14-2014, 12:24 AM
  2. Insert Rows between unlkike cells, copy paste, then delete
    By am_hawk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-21-2013, 02:13 PM
  3. Copy Paste the Missing Values in a Specified Cells and Insert the Rows into a Report
    By judeprem in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-30-2013, 01:46 PM
  4. Excel Macro to insert two rows based on condition and copy and paste multiple cells
    By mannabhalo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-13-2012, 12:56 PM
  5. Copy Sheet / Create & Name New Sheet / Insert Before a Sheet / Paste Data
    By thinkspac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2012, 02:27 PM
  6. [SOLVED] Code to cut and paste rows (insert cut cells) in a protected Excel sheet
    By bob.mc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2012, 04:47 PM
  7. Copy paste data, insert rows, insert data and change . to -
    By xWiZardx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-16-2010, 01:44 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