根据excel的某列将excel分成不同的sheet
1、准备好excel
2、点alt + f11
3、点击 插入模块
4、贴入代码
Sub Splitdatabycol()
Dim lr As Long
Dim ws As Worksheet
Dim vcol, i As Integer
Dim icol As Long
Dim myarr As Variant
Dim title As String
Dim titlerow ...
转载
2019-09-09 16:05:09 ·
3488 阅读 ·
0 评论