从3个工作簿中制作一个Excel表格摘要并将其链接 [英] Making a summary excel sheet from 3 workbooks and linking them

问题描述

我想知道如何做到这一点，我有3本工作簿，每本都有1列相同但数据不同的通用表.我的任务是合并这3个工作表中的数据并创建一个新的摘要工作表.
摘要表应链接到这三本单独的工作簿，以便在工作簿中所做的任何更改都应反映在摘要表中，请引导我完成此任务

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

推荐答案

首先查看Excel帮助-例如搜索合并工作簿".

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

这篇关于从3个工作簿中制作一个Excel表格摘要并将其链接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！