Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
This macro was coded from here on this site (thanks for everyones help) and
it basically takes all the information from every worksheet in the workbook and compiles it into one long list of data. Sub UpdateMaster() Dim ws As Worksheet 'Utility worksheet variable Dim Dest As Range 'The cell in Col B of Master sht in which to paste If Range("A" & Rows.Count).End(xlUp).Row 1 Then Range("A2", Range("B" & Rows.Count).End(xlUp).Offset(2, -1)).Resize(, 13).ClearContents End If Set Dest = Range("B2") For Each ws In ActiveWorkbook.Worksheets If ws.Name < "Master" Then Dest.Offset(, -1).Value = ws.Name With ws .Range("A2", .Range("A" & Rows.Count).End(xlUp)).Resize(, 12).Copy Dest Set Dest = Range("B" & Rows.Count).End(xlUp).Offset(2) End With End If Next ws End Sub My question is, how do I get it to ignore the first worksheet in the workbook? Is there some command I can give to do this in the code? Any help is appretiated.. If this is too vague I'll try and make my question more specific |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro editing | Excel Discussion (Misc queries) | |||
Editing a macro | Excel Discussion (Misc queries) | |||
Editing a macro | Excel Discussion (Misc queries) | |||
Editing a Macro | Excel Discussion (Misc queries) | |||
Editing Macro | Excel Discussion (Misc queries) |