根据excel的某列将excel分成不同的sheet
1、准备好excel2、点alt + f113、点击 插入模块4、贴入代码Sub Splitdatabycol()Dim lr As LongDim ws As WorksheetDim vcol, i As IntegerDim icol As LongDim myarr As VariantDim title As StringDim titlerow ...
转载
2019-09-09 16:05:09 ·
3793 阅读 ·
0 评论
关注
分享
扫一扫