Control Few Workbook Data in One

[JERRY89]

Hi All,
May I ask is there any books or learning material on controlling few workbook data in one as I need to control few workbook that contain summary data to be link in one master workbook.

[Rudi]

Hi Jerry,

These links and videos should provide you all the info you need to help with setting up your workbook and linked formulas.

Videos:
- Excel 2013 tutorials - Multiple Worksheets and Workbooks - Managing Links
- How to link two (multiple) workbooks and cells in Excel
- Excel Magic Trick #182: Workbook References (More advanced, but good details)

Tutorials:
- Create an external reference (link) to a cell range in another workbook
- External References
- How to Link Excel Spreadsheet Data
- How to create external reference in Excel to refer to another sheet or workbook

[JERRY89]

Hi Mr Rudi,

Thanks Alot for your links, it is really great.It help me alot.