宏将工作表拆分为多个 [英] Macro to split worksheet into multiple

问题描述

我有一个工作表，我想分成4个其他工作表。但是，我需要在转移时将分组的行保持在一起。 我希望将它拆分的方式是每4行。  I.e. 第2行和第6行将
转移到同一工作表。 请注意，标题也需要转移到新的4个工作表中。 有谁知道如何创建这种类型的宏？

Hi, I have a worksheet that I would like to split into 4 other worksheets. However, I need to keep the grouped rows together when transferring.  The way I would like for it to be split is by each 4th row.  I.e. row 2 and row 6 would be transferred to the same worksheet.  Keep in mind that the header would also need to be transferred to each of the new 4 worksheets.  Does anyone know how to create this type of macro?

请帮助！

推荐答案

Excel 2010/2013/2016 Power Query（又名Get& Transform）
$
直接使用宏，但这是PQ的后续方法。 />
http://www.mediafire.com/file/ziawewcpczz3wpl/11_02_17.xlsx

这篇关于宏将工作表拆分为多个的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！