How to merge sheets in One Excel file

[rush2rajen]

Hi,

Please find the attached file.
I want to merge all the sheets named " A, B, C, D, E" to sheet 1.
Is there any macro which can help me in merging all the sheets

This is because i am having 100 of sheets with different name.

Regards
Raj

 

[Marc L]

Hi !

A demonstration according to your sample workbook :​

Sub Demo()
    Application.ScreenUpdating = False
For W& = 2 To Worksheets.Count
    Worksheets(W).UsedRange.Offset(-(W > 2)).Copy Sheet1.Cells(R& + 1, 1)
    R = Sheet1.Cells(1).End(xlDown).Row
Next
    Application.ScreenUpdating = True
End Sub

Do you like it ? So thanks to click on bottom right Like !
​

 

[rush2rajen]

Hi Marc,

Thanks a lot. Can you please elaborate the same as because I am unable to see the sheets name A,B,C,D,E.

Thanks
Raj

 

[Marc L]

Did you ever try my demonstration on your sample workbook ?
​

 

[rush2rajen]

Hi Marc,
I had checked and it working fine.

Thanks
Raj

 

[Marc L]

So you saw names are not necessary …
​