Adding Sheets till specific value

[ppr (Peter Preuss)]

@Daniyal_Tahir
have a look on following links:

for the concept:

Process repeated for each multiple rows

@christine.tzenghy let me introduce a general approach that can be also adopted to more case specific details. Assumptons: DataTable with 8 Rows Segmentsize: 3 Following Building Blocks are used Calculation of the numbers of segments: [grafik] with the Ceiling method the fractions are uprounded to the next Integer with the Skip() and Take() Method the Rows for a segment can be retrieved. the different segments are bult by following [grafik] and do fetch the different segment rows by: …

other demo

Split datatable into batches

can be done with skip take: in the combination with copytodatatable split results are datatables: