Hi Team,
Could someone please help to copy multiple workbook from a folder to single workbook.
For example I have 3 workbook and it has 3 sheets (Sheet1, sheet2 and sheet3)
I need to copy the values from all the workbook and paste it in Masterwork book.
Please find the below as an example.
Book1, Sheet1:
Book2, Sheet1:
Master Book, Sheet1
Note:
Few sheets has data and few sheets are empty.
Please help me guys!! Thanks a lot in advance.
Could someone please help to copy multiple workbook from a folder to single workbook.
For example I have 3 workbook and it has 3 sheets (Sheet1, sheet2 and sheet3)
I need to copy the values from all the workbook and paste it in Masterwork book.
Please find the below as an example.
Book1, Sheet1:
Book1, Sheet2:Name Age Location
Sri 25 Chennai
Sathish 25 Erode
Prabhakaran 25 Madurai
Book1, Sheet3:Desg Office
Manager DLF
Sen Mana Porur
Likewise i have the details in the other work book.Status Loan Status
Active No
Active Yes
Not Active Yes
Active No
Book2, Sheet1:
Book2, Sheet2:Name Age Location
Vinoth 26 Vandaloor
Rajesh 27 Karaikudi
Vignesh 25 Coimbatore
Book2, Sheet3:Desg Office
Manager DLF
Sen Mana Porur
Now my requirement is, in the Master workbook I need the consolidate.Status Loan Status
Active No
Active Yes
Not Active Yes
Active No
Master Book, Sheet1
Master Book, Sheet2:Name Age Location
Sri 25 Chennai
Sathish 25 Erode
Prabhakaran 25 Madurai
Vinoth 26 Vandaloor
Rajesh 27 Karaikudi
Vignesh 25 Coimbatore
Master Book, Sheet3:Desg Office
Manager DLF
Sen Mana Porur
Manager DLF
Sen Mana Porur
Status Loan Status
Active No
Active Yes
Not Active Yes
Active No
Active No
Active Yes
Not Active Yes
Active No
Note:
Few sheets has data and few sheets are empty.
Please help me guys!! Thanks a lot in advance.