将选定的表格合并到一个主表格中 [英] 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屋！