Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Jamil Akram   on Sep 08 In MS Office Category.

MERGE TWO SHEET IN ONE NEW SHEET


  
Question Answered By: Muntasir Bashara   on Sep 08

Sub Merge_ABC()
Dim rng As Range, ws As Worksheet
Set ws = Sheets("Report")
ws.Cells.ClearContents
Sheets("WorkA").UsedRange.Copy ws.Range("A1")
Sheets("WorkB").UsedRange.Copy ws.Range("A" & ws.Range("A65536").End
(xlUp).Row + 3)
Sheets("WorkC").UsedRange.Copy ws.Range("A" & ws.Range("A65536").End
(xlUp).Row + 3)
End Sub

Share: 

 

View Complete Question Thread

 
Didn't find what you were looking for? Find more on MERGE TWO SHEET IN ONE NEW SHEET Or get search suggestion and latest updates.


Tagged: