-
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
-
HTML5鼠标控制彩色气泡特效
HTML5鼠标控制彩色气泡特效是一款html5 canvas绘制网页经过跟随鼠标移动漫天飞舞的彩色圆球动画。(HTML5 mouse-controlled color bubble effect is a color sphere animation that HTML 5 canvas draws web pages and flies through the sky following the mouse movement.)
- 2019-01-13 18:36:33下载
- 积分:1
-
wear
说明: Abaqus中使用Archard理论计算关节磨损的子程序(Subroutine of using arcard theory to calculate joint wear in ABAQUS)
- 2020-05-10 01:23:34下载
- 积分:1
-
PF
说明: 学习粒子滤波的简单实例 先把原理看明白 再逐行看代码很简单(a simple example of particle filtering)
- 2019-03-29 00:29:17下载
- 积分:1
-
to use MATLAB simulation and control systems operation
运用MATLAB对控制系统进行仿真操作-to use MATLAB simulation and control systems operation
- 2022-02-09 19:44:03下载
- 积分:1
-
7.STM32F105_CAN双机通信
里面包含stm32f105系列使用can总线实现双机通信源代码,已通过调试(It contains stm32f105 series source code for dual-computer communication using can bus, which has been debugged.)
- 2018-11-29 16:29:40下载
- 积分:1
-
降雨反演数据提取
TRMM热带卫星降雨数据,MATLAB处理程序(tropical satellite rainfall data, MATLAB processing procedures)
- 2018-01-25 16:27:05下载
- 积分:1
-
svm
svm算法源代码,对数据挖掘等都很有用的(SVM algorithm source code, for data mining is very useful)
- 2008-12-27 10:39:38下载
- 积分:1
-
JavaDesign
21点小游戏,本游戏用于无聊时消遣用,欢迎各位同志下载(the game of 21)
- 2012-06-17 22:31:25下载
- 积分:1
-
FIR
说明: 基于MATLAB的低通、高通、带通、带阻FIR滤波器仿真代码(Matlab based low pass, high pass, band pass, band stop FIR filter simulation code)
- 2021-04-24 22:30:52下载
- 积分:1