Paste 10 or more worksheets data in a single worksheet

[Closed]
Report
Posts
4
Registration date
Sunday November 10, 2013
Status
Member
Last seen
February 16, 2014
-
Posts
4
Registration date
Sunday November 10, 2013
Status
Member
Last seen
February 16, 2014
-
I want paste 10 or more worksheets data in a single worksheet by using formula, is it possible??

Thanks in advance

Mahfuz

2 replies

Posts
7
Registration date
Thursday December 26, 2013
Status
Member
Last seen
January 5, 2014

hi,
The below code pulls the data from the all the sheets and it will paste it different sheet called summary which you need to rename to one of the tab

Sub SummurizeSheets()
Dim ws As Worksheet
Application.ScreenUpdating = False
Sheets("Summary").Activate
Sheets("Summary").UsedRange.Clear
For Each ws In Worksheets
If ws.Name <> "Summary" Then
ws.UsedRange.Copy
ActiveSheet.Paste Range("A65536").End(xlUp).Offset(1, 0)
End If
Next ws
End Sub
Posts
4
Registration date
Sunday November 10, 2013
Status
Member
Last seen
February 16, 2014

Thanks a lot Honey85209. Is it possible in excel formula as i m not used to in VBA Macro.

Regards
Mahfuz