Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from multiple worksheets
Les
The following macro is one way. Note that the new sheet must be the active sheet. I assumed the name of the new sheet is "New". That name is in the macro. Change that as you wish. HTH Otto Sub CopyA1() Dim ws As Worksheet Dim Dest As Range Set Dest = Range("A" & Rows.Count).End(xlUp).Offset(1) For Each ws In ActiveWorkbook.Worksheets If ws.Name = "New" Then GoTo NextSheet With ws .Range("A1").Copy Dest Set Dest = Dest.Offset(1) End With NextSheet: Next ws End Sub "Les" wrote in message ... Can anyone help please? I'm trying to create a macro to copy the contents of cell 'A1' from each worksheet and paste them into a list in a new sheet. Regards Les. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy data in multiple worksheets | New Users to Excel | |||
Copy only certain data from multiple worksheets | Excel Discussion (Misc queries) | |||
Copy information from multiple worksheets | Excel Discussion (Misc queries) | |||
Is there a way to copy multiple worksheets into one, row by row? | Excel Worksheet Functions | |||
VBA: Copy from columns on multiple worksheets | Excel Programming |