How do I pull data from multiple worksheets into one?

Question Posted / yogesh shukla

1 Answers
718 Views
I also Faced
E-Mail Answers

How do I pull data from multiple worksheets into one?..

Answer / Harsh Mani Singh

"To pull data from multiple worksheets into one, you can use Excel's VBA (Visual Basic for Applications). Here is a simple example:

1. Press Alt + F11 to open the VBA editor.
2. Click on Insert > Module.
3. Paste the following code:

```vba
Sub PullData()
Dim SourceSheet As Worksheet
Dim DestinationSheet As Worksheet
Dim LastRowSource As Long
Dim LastRowDest As Long

Set SourceSheet = ThisWorkbook.Sheets("Sheet1") 'Change to the source sheet name
Set DestinationSheet = ThisWorkbook.Sheets("Sheet2") 'Change to the destination sheet name

LastRowSource = SourceSheet.Cells(SourceSheet.Rows.Count, "A").End(xlUp).Row
LastRowDest = DestinationSheet.Cells(DestinationSheet.Rows.Count, "A").End(xlUp).Row + 1

DestinationSheet.Range("A" & LastRowDest).Resize(SourceSheet.Rows.Count).Value = SourceSheet.Range("A1:A" & LastRowSource).Value
```

4. Press Ctrl + S to save the module, and Close the VBA editor."