将选定的表格合并到一个主表格中 [英] Combining Selected Sheets into one Master Sheet
问题描述
我确定这是一个非常简单的场景,但我无法解决这个问题。 我有一张包含多张表的工作簿。我希望能够只选择其中两张或三张并将它们合并为一张主张。让我们称之为 - 股票表1,
股票表2和主表。库存表1和2具有完全相同的列标题,但行数将不时增加和减少。我希望它们作为主表中的一个长列表运行。
$
文件中的表格我不想包含在主表格中。
$
我曾经创造过一次,但无法弄清楚我是怎么做到的。我知道我有一个宏按钮,我需要点击以更新列表。谢谢!
I am sure this is quite a simple scenario, but I cannot work it out. I have a Workbook with several sheets. I want to be able to select just two or three of those sheets and combine them into one master sheet. Lets call them - Stock Sheet 1,
Stock Sheet 2 and Master Sheet. Stock Sheet 1 and 2 have exactly the same column headers, but the number of rows will increase and decrease from time to time. I want them to run as one long list in the Master Sheet.
There are sheets in the document that I do not want to include on the Master Sheet.
I have created this once before but cannot work out how I did it. I know I had a Macro button which I would need to hit to update the list. Thank you!
推荐答案
您好,
您能否在宏按钮中提供代码?
问候,
Hi,
Could you provide your code in a Macro button?
Regards,
这篇关于将选定的表格合并到一个主表格中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!