• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multiple workbook to Master workbook in a folder

venugosr

New Member
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:
Name Age Location
Sri 25 Chennai
Sathish 25 Erode
Prabhakaran 25 Madurai
Book1, Sheet2:
Desg Office
Manager DLF
Sen Mana Porur
Book1, Sheet3:
Status Loan Status
Active No
Active Yes
Not Active Yes
Active No
Likewise i have the details in the other work book.
Book2, Sheet1:
Name Age Location
Vinoth 26 Vandaloor
Rajesh 27 Karaikudi
Vignesh 25 Coimbatore
Book2, Sheet2:
Desg Office
Manager DLF
Sen Mana Porur
Book2, Sheet3:
Status Loan Status
Active No
Active Yes
Not Active Yes
Active No
Now my requirement is, in the Master workbook I need the consolidate.
Master Book, Sheet1
Name Age Location
Sri 25 Chennai
Sathish 25 Erode
Prabhakaran 25 Madurai
Vinoth 26 Vandaloor
Rajesh 27 Karaikudi
Vignesh 25 Coimbatore
Master Book, Sheet2:
Desg Office
Manager DLF
Sen Mana Porur
Manager DLF
Sen Mana Porur
Master Book, Sheet3:
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.
 
Just follow tutorials, VBA inner help, use Macro recorder, …

As we do not want to waste time if you already had an answer
on another forum 'cause we can't check without any link
as yet explained in last link of my previous post !
 
Back
Top