combine sheets into one sheet | combine multiple excel sheets into one sheet vba | EXCEL |
hi i am manoj kumar
IN THIS video we are going to learn about the how to get the data from multiple sheets to one sheet within second, with the help of VBA,
***** vba code******
Public Sub dataconnection()
Dim i As Integer
For i = 1 To Worksheets.Count - 2
Worksheets(i).Select
Range("a2").Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.Copy
Worksheets("Repoarts").Select
Range("a1048576").Select
Selection.End(xlUp).Select
ActiveCell.Offset(1, 0).Select
ActiveSheet.Paste
Next i
End Sub
Combine Data From Multiple Worksheets into a Single Worksheet in Excel
Learn how to consolidate data in an excel sheet from different multiple sheets
combine multiple excel sheets into one sheet VBA
by @manojkumarexcel
from bhorha, simri bakhtiyarpur,saharsa,bihar,