+ Reply to Thread
Results 1 to 4 of 4

Insert a Copy of an Entire Row (including formatting) from Sheet2 to Sheet1

  1. #1
    Registered User
    Join Date
    02-27-2015
    Location
    canada
    MS-Off Ver
    2013
    Posts
    3

    Insert a Copy of an Entire Row (including formatting) from Sheet2 to Sheet1

    Hi,

    1. I need a macro that will allow me to copy an entire row from Sheet2 to Sheet1.
    2. The row being copied has merged cells and other formatting. I need the inserted row to retain the formatting.
    3. I want to insert the row below the active cell in Sheet1

    Thanks

  2. #2
    Registered User
    Join Date
    02-27-2015
    Location
    canada
    MS-Off Ver
    2013
    Posts
    3

    Re: Insert a Copy of an Entire Row (including formatting) from Sheet2 to Sheet1

    Sorry but I forgot to add a 4th requirement.

    4. The row is being inserted in the middle of a sheet filled with data so I need the macro to first insert a new row below the active cell. That way the inserted row is pasted on the new row and will not overwrite existing data.

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Insert a Copy of an Entire Row (including formatting) from Sheet2 to Sheet1

    You don't say which row to copy but this code will copy row 4 from Sheet1 and insert it at the active cell on Sheet2.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  4. #4
    Registered User
    Join Date
    02-27-2015
    Location
    canada
    MS-Off Ver
    2013
    Posts
    3

    Re: Insert a Copy of an Entire Row (including formatting) from Sheet2 to Sheet1

    Thanks Norie. I tried your suggestion but I get an error on the following line

    Sheets("Sheet2").Rows(ActiveCell.Row).Insert

+ 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] Macro copy entire row if any cell frm col A in sheet1 match any cell frm col A in sheet2
    By daillest319 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-28-2013, 03:20 PM
  2. Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  3. [SOLVED] Take Data From Column on Sheet1 and Insert Into Next Blank Row on Sheet2 Then Clear Sheet1
    By abutler911 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2013, 06:30 PM
  4. Looking for help to copy a value from sheet1 and insert a new row in Sheet2
    By cdraudt13 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-05-2013, 11:48 PM
  5. [SOLVED] Copy and Paste Entire Row from Sheet1->Sheet2 based on text string match in Sheet1 Row
    By dmlovic in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-17-2012, 08:42 AM
  6. Find random variable from sheet1, in sheet2, and copy entire row to sheet3
    By TMorville in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-12-2010, 06:27 AM
  7. Replies: 4
    Last Post: 08-30-2007, 07:14 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