Tech Support Guy banner
Status
Not open for further replies.
1 - 2 of 2 Posts

·
Registered
Joined
·
1 Posts
Discussion Starter · #1 ·
hi , any one can help me ? how to copy&paste data cell from multiple work sheets(total 50 worksheets) onto to new work sheets (monthly report)
for sample , on worksheet 1. A1 cells value is 45
work sheet 2. A1 cells value is 32
work sheets 3. A1 cells value is 56
and alll value cells (45,32& 56) will paste to monthly report worksheet


thank raslaffan
 

·
Registered
Joined
·
8,546 Posts
excell code
Sub Macro1()
Sheets.Add Before:=Sheets(1)
ActiveSheet.Name = "Monthly Report"
For i = 1 To Sheets.Count - 1
Cells(i, 1) = Sheets(i + 1).Cells(1, 1).Value
Next i
End Sub

Welcome to the board.
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top