-
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
-
20075219384666072
考试系统源码,vb开发,一个网友的作品编得非常不错.()
- 2007-10-05 09:21:00下载
- 积分:1
-
student-information-database
数据库基本功能都可以实现,删除,添加等等(this program is useful for people who want to develop database)
- 2013-10-28 19:51:16下载
- 积分:1
-
myodbc-2_50_17a-src
MySQL的ODBC接口源码(The sourcecode of ODBC interface for MYSQL)
- 2020-11-10 20:39:46下载
- 积分:1
-
VFP
VFP数据库继承了以往传统数据库的优点,是采用了面向对象的程序设计思想和可视化的编程工具,操作简单、易学,极大的方便了软件的开发。人们在使用它作为开发工具时,可以高效的开发出全新的可视化图形界面应用程序。(VFP database inherits the advantages of traditional databases, is the use of object-oriented program design and visual programming tools, simple operation, easy to learn, which greatly facilitates the software development. People use it as a development tool, you can efficiently develop a new visual GUI applications.)
- 2013-08-30 16:02:33下载
- 积分:1
-
jiaowufuzhuguanli
本人课程设计做的一个简单的教务辅助管理系统,实现了数据库的一般操作,适合初学者学习使用.初始用户密码均为admin.(I do curriculum design a simple Senate supporting management system, a database of normal operation for beginners to learn how to use. Initial users are admin password.)
- 2007-05-23 11:38:29下载
- 积分:1
-
student-information-database
数据库基本功能都可以实现,删除,添加等等(this program is useful for people who want to develop database)
- 2013-10-28 19:51:16下载
- 积分:1
-
lending-Form
A very simple VB Source that can read / write from access database to Grid
- 2013-02-24 07:45:01下载
- 积分:1
-
仓库管理系统100
仓库管理系统简单版(warehouse management system simpler version)
- 2020-11-06 11:59:49下载
- 积分:1
-
20059211281636
软件界面友好,包含了进销存的基本功能,可在此基础上进一步开发。 (Friendly software interface, contains the basic functions Invoicing can be further developed on this basis.)
- 2010-08-06 17:23:44下载
- 积分:1