Results 1 to 7 of 7

Copy and Append data to another sheet

Threaded View

  1. #1
    Registered User
    Join Date
    08-29-2016
    Location
    NL
    MS-Off Ver
    2016
    Posts
    4

    Copy and Append data to another sheet

    Hi all,

    I'm trying to copy and append rows from multiple sheets to one main overview sheet. The VBA underneath works, but if the script executes the second sheet, it starts at the first row. So the rows from the first sheet are overwritten. Can anyone help to get the rows appended from the second, thirt, fourth etc ?

    Thanks

    ------------------------------------------------------------------------------------------
    Sub CopySheet_Sheet1()
    
     Dim bottomL As Integer
        bottomL = Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row: x = 1
    
        Dim c As Range
        For Each c In Sheets("Sheet1").Range("A6:A" & bottomL)
            If c.Value >= "1" Then
                c.EntireRow.Range("C1:D1:E1:F1:G1:H1:I1:J1:K1:L1:M1:N1:O1").Copy
                Worksheets("TotalSHeet").Range("A" & x + 1).PasteSpecial xlValues
                Application.CutCopyMode = False
                x = x + 1
            End If
        Next c
    
    End Sub
    -------------------------------------------------------------------------------------------
    Last edited by alansidman; 08-29-2016 at 10:07 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy row from one sheet and append it to the second sheet
    By saidineshbabu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2015, 02:38 AM
  2. Replies: 2
    Last Post: 01-22-2014, 05:36 PM
  3. Copy table01, append to tableA on another sheet, create sub-tables therein
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2014, 06:12 PM
  4. copy from one sheet and append in another one
    By mmf in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-01-2013, 02:06 AM
  5. Replies: 1
    Last Post: 07-17-2012, 11:05 PM
  6. [SOLVED] Select file, Copy Worksheet Range and Append onto 1 Sheet
    By Tellm in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-03-2012, 03:27 PM
  7. Find in text - and copy/append to other sheet
    By excaliburst in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-28-2009, 11:29 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