且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

用于将一个工作表数据拆分为多个工作表的宏代码

更新时间:2023-01-24 19:25:22

需要更多信息。

Need more information.

无论源数据中的行数是多少,它总是20张,只需将它分开源数据中的行数为20?

Will it always be 20 sheets irrespective of the number of rows in the Source data and simply divide the rows in source data by 20?

或者它总是500行,并且使用更多工作表来包含500行。?

Or will it always be 500 rows and use more sheets to contain the 500 rows each.?

如果不完全可以分割成每张纸的相同行数,那么我假设最后一张纸只有更少的行?

If not exactly divisible into equal number of rows for each sheet then I assume that last sheet simply have less rows?

参考上一个问题,如果在等分之后只留下几行行,你想要只有几行的附加工作表,或者可以增加最后2或3页的少量数量,以避免
工作表上的行数极少吗?如果是后者,最后一张纸上的最小行数是多少?

Referring to previous question, if only a few rows left over after equal division of rows, do you want additional sheet with only a few rows or maybe increment last 2 or 3 sheets by a small amount to avoid an exceptionally small number of rows on a sheet? If the latter, what is minimum rows to place on last sheet?