-
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
-
MSPRO
利用MFC开发的数据库系统,用的是微软的Access,有详细的链接数据库的代码。(Use of MFC development of database systems, using Microsoft Access, there are more links to the database code.)
- 2011-09-06 21:40:03下载
- 积分:1
-
vb-access
visual basic和access 数据库开发实例 (vb access database)
- 2011-12-06 23:23:11下载
- 积分:1
-
SetAccessData
对已经存在的Accsess数据库表添加新字段并复值(right Accsess already existing database table and add a new field of Complex)
- 2006-08-10 21:15:31下载
- 积分:1
-
miniSQL
MiniSQL的大致架构在里面了,可以自己填写里面的模块。。(MiniSQL the general framework in which, you can fill out inside the module. .)
- 2011-10-14 22:39:17下载
- 积分: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
-
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
-
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
-
testdatabasedll
数据库功能展示,vc连接access数据库,实现增删查找功能(Database function display, vc connection access database, add or delete search function to achieve)
- 2011-01-24 17:04:23下载
- 积分:1
-
Population
c++ 链接access 建立的一个小型人员统计系统管理 代码简单(c++ link access to the set of a small staff Biejiao simple statistical system management code)
- 2014-03-09 10:11:57下载
- 积分:1