How to split an Excel sheet into two individual workbook based on whether it contains specific strings?

Hi,

can you try the following sample?

dict = dt.AsEnumerable.GroupBy(Function(r) r("School").ToString).ToDictionary(Function(g) g.Key,Function(g) g.CopyToDataTable)

Sample
Sample20230927-7Lv2.zip (9.4 KB)

Regards,

1 Like