-
N-sheets
以G列分成多个工作表(以宏运行VBA)
(Sub aa()
Dim a As Integer, b As Integer, c As Integer, sh As Worksheet
For a = 2 To [g65536].End(3).Row
If Cells(a, 7) <> Cells(a- 1, 7) Then
b = a
End If
c = Range("g:g").Find(Cells(a, 7), , , , , xlPrevious).Row
Set sh = Sheets.Add(, Sheets(Sheets.Count))
sh.Name = Sheets("sheet1").Cells(a, 7).Value
With Sheets("Sheet1")
Sheets("Sheet1").Range(.Cells(b, 1), .Cells(c, 10)).Copy Destination:=sh.[a2]
Sheets("Sheet1").Range("a1:j1").Copy Destination:=sh.[a1]
a = c
End With
Sheets("Sheet1").Select
Next
End Sub
)
- 2013-05-03 08:50:54下载
- 积分:1
-
sysmain
说明: VFP开发的主控程序,其中用了多种方法和技巧实现对用户权限的控制和选择。(VFP development of the control procedures, which use a variety of methods and techniques to achieve competence of the user control and choice.)
- 2006-03-14 00:15:36下载
- 积分:1
-
mongodb-src-r3.2.4.tar
memory mapped noSQL database engine
- 2017-09-29 18:26:17下载
- 积分:1
-
apriori
关联规则挖掘算法
Apriori算法的Matlab实现 可以自动生成关联规则,计算支持度、置信度(Association Rules Mining Algorithm Apriori algorithm can automatically generate Matlab realization of association rules, computing support, confidence)
- 2020-11-29 22:19:29下载
- 积分:1
-
sqlite-3_3_7
sqlite-3_3_7 源代码,最稳定的sqlite源码,可以编译成linux、windows、mac等版本(sqlite-3_3_7 源码)
- 2013-11-04 14:13:46下载
- 积分:1
-
wlcsxt
说明: 网络测试系统,很实用的一个源码,很有参考价值,下载试试,多学习哦(Network test systems, it is a source of practical, useful reference, download a try, more to learn Oh)
- 2008-11-23 22:37:15下载
- 积分:1
-
2004051317015414293
我做了一套银行帐户管理系统,功能还可以,愿与大家分享,共同进步.(I had a bank account management system, can also function, and is willing to share with you, and common progress. Thank you)
- 2007-03-24 13:54:26下载
- 积分:1
-
sqlite-amalgamation-3071700
sqlite数据库C源码接口程序,通过此程序可以创建,修改和删除SQLITE数据及数据(sqlite database C source interface program, through this process can create, modify, and delete data, and data SQLITE)
- 2013-07-17 16:28:51下载
- 积分:1
-
LabVIEW
利用access数据库开发的用户登录界面(User Login System design by LabVIEW)
- 2018-06-16 22:47:44下载
- 积分:1
-
ADO
这是ACCESS的数据库编程文件,可以容易的用在MFC,VC,DELPH等工程环境(ACCESS ADO DATABASE ,MFC VS2008 AND VS2010)
- 2013-08-18 10:30:52下载
- 积分:1