View Single Post
 
Old 03-14-2018, 06:48 PM
Logit Logit is offline Windows 10 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 591
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

.
Paste in Routine Module :

Code:
Option Explicit

Sub Maybe()
    Dim sh As Worksheet
    If Not [ISREF(Combined!A1)] Then
        Sheets.Add(, Sheets(Sheets.Count)).Name = "Combined"
    Else
        Sheets("Combined").UsedRange.EntireColumn.Delete
    End If
    'Sheets("Sheet2").Rows(1).Copy Sheets("Combined").Cells(1, 1)  ' Not needed
    For Each sh In ActiveWorkbook.Sheets
        If sh.Name <> "Combined" Then sh.UsedRange.Offset(1).Copy Sheets("Combined").Cells(Rows.Count, 1).End(xlUp).Offset(1)
    Next sh
End Sub
This macro creates a sheet named "Combined", then copies/pastes all info from each sheet to the new sheet Combined.
Reply With Quote