-
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
-
VCDatabaseOpraterADO
说明: VC操作ADO和datagrid控件的源码,是动态的的。不受目录改变的限制(ADO and VC operation datagrid source control is the dynamic. From the directory to change the restrictions)
- 2009-07-30 20:58:21下载
- 积分:1
-
ADO
这是ACCESS的数据库编程文件,可以容易的用在MFC,VC,DELPH等工程环境(ACCESS ADO DATABASE ,MFC VS2008 AND VS2010)
- 2013-08-18 10:30:52下载
- 积分:1
-
tuishuiguanli
VB编写的退税管理系统,可做毕业设计参考,很适用!(VB prepared the tax rebate management system, can be graduated from the reference design, it is applicable!)
- 2008-12-29 16:20:26下载
- 积分:1
-
chuti
基于VFP的出题小系统,以前做的,传上来分分享一下(Test system based on VFP, before doing, Chuan up points to share)
- 2014-08-27 18:40:49下载
- 积分:1
-
SQLite3Develop
Sqlite3 的确很好用。小巧、速度快。但是因为非微软的产品,帮助文档总觉得不够。这
些天再次研究它,又有一些收获,这里把我对 sqlite3 的研究列出来,以备忘记。(Sqlite3 really good use. Small, fast. But for the Microsoft products, always feel that not enough to help document. This
Some day to study it, and have some harvest, here I study on SQLite3 list, to forget.)
- 2012-09-25 17:13:03下载
- 积分:1
-
StudentCheck
职责描述:,系统信息设计,学生出操考勤管理、学生上课考勤管理、学生参加活动考勤管理,学生寝室考勤管理,综合统计与查询等六大模块。
项目简述:该系统利用MFC框架 Excel工具开发,来实现学生考勤管理。()
- 2008-03-15 21:13:11下载
- 积分:1
-
Tele
VC进行数据库编程,MFC编写的,可以与CListCtrl控件配合使用(VC database programming, MFC prepared can be used in conjunction with the CListCtrl control)
- 2009-04-11 17:38:22下载
- 积分:1
-
test_database
利用mfc编程实现acess数据库的存储与访问,对于小型的数据库很实用(Mfc programming using acess database storage and access, the database is very useful for small)
- 2011-11-29 10:27:49下载
- 积分: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