-
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
-
Intellectual games, with the street grid on behalf of housing, asked to enter in...
智力游戏,用方格代表街道房屋,要求输入信息之后计算最多可以有多少枪手,同时存在在城市中而不会相互射击,原来是ACM竞赛的赛题-Intellectual games, with the street grid on behalf of housing, asked to enter information after the calculation of maximum number of gunmen, at the same time the existence in the city and not shooting each other, the original is ACM Cup title race
- 2022-05-24 03:55:32下载
- 积分:1
-
qzw3
说明: 实现偏振图像的偏振度和偏振相角的融合,并实现融合后的图像与强度图像融合,比较梯度等信息(Fusion of polarization degree and polarization phase angle of polarized image, fusion of fused image and intensity image, comparison of gradient and other information are realized.)
- 2021-03-31 21:09:08下载
- 积分:1
-
440-827-4-PB
说明: image segmentation with svm and ERSS arimoto entropy form color and texture
- 2020-08-04 00:22:38下载
- 积分:1
-
一个很好用的MPEG2
一个很好用的MPEG2-TS流分析软件,内含序列号,保证可以使用-A good use of MPEG2-TS stream analysis software, including the serial number to ensure that you can use
- 2022-05-23 12:43:09下载
- 积分:1
-
Rotate
Examples c++Builder6
- 2011-11-04 22:50:51下载
- 积分:1
-
code assigmenrt anwser
machine learning assignment
- 2020-06-24 21:40:01下载
- 积分:1
-
unix系统管理基础教程.是认证培训的基本教程,权威性较高.
unix系统管理基础教程.是认证培训的基本教程,权威性较高.-based tutorial. Certification training is a basic guide, a higher authority.
- 2023-05-02 22:40:03下载
- 积分:1
-
HSS
HSS算法程序,matlab编写,方法很好很有用,程序很简单(The HSS algorithm program, written by Matlab, is very good and useful. The program is very simple.)
- 2018-07-11 09:17:06下载
- 积分:1
-
斯皮尔曼相关系数
斯皮尔曼相关性,斯皮尔曼系数一般有两个公式,由排行差分集合d计算而得(公式一)由排行集合x、y计算而得(斯皮尔曼等级相关系数同时也被认为是经过排行的两个随机变量的皮尔逊相关系数,以下实际是计算x、y的皮尔逊相关系数)(公式二)(different types functions)
- 2017-12-18 11:29:23下载
- 积分:1