Click here to Skip to main content
14,773,203 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i was wondering how to do this, i have 3 work books each have 1 common sheet with same columns but different data. My task is to merge data from those 3 sheets and create a new summary sheet.
The summary sheet should be linked to those 3 individual work books,such that any changes done in those work books it should reflect in the summary sheet, kindly guide me through this task

1 solution

Start by looking at the Excel Help - say, for instance searching for Merge Workbooks.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900