5,139
社区成员
发帖
与我相关
我的任务
分享
sub extractInfo(byval startTime as date, byval endTime as data , byval resultsheet as worksheet, byval sourcesheet as worksheet)
dim r_rowindex, s_rowindex, lastRow as integer
dim timeStr as String
r_rowindex = 4
s_rowindex = 4
' 找到最后一行 resultsheet 存放结果的sheet页
do while resultsheet.cells(rowindex, 2).value <> ""
r_rowindex = r_rowindex + 1
loop
do while sourcesheet.cells(s_rowindex, 4).value <> ""
timeStr = sourcesheet.cells(s_rowindex, 4).value
'通过时间筛选出符合条件的记录
if idDate(timeStr ) and startTime < timeStr and timeStr < endTime then
‘列赋值(有很多单元格的字符很多)
reusltsheet.cells(r_rowindex , 2).value = source.cells(s_rowindex, 1).value
reusltsheet.cells(r_rowindex , 2).value = source.cells(s_rowindex, 1).value
reusltsheet.cells(r_rowindex , 2).value = source.cells(s_rowindex, 1).value
reusltsheet.cells(r_rowindex , 2).value = source.cells(s_rowindex, 1).value
reusltsheet.cells(r_rowindex , 2).value = source.cells(s_rowindex, 1).value
reusltsheet.cells(r_rowindex , 2).value = source.cells(s_rowindex, 1).value
reusltsheet.cells(r_rowindex , 2).value = source.cells(s_rowindex, 1).value
’对该列数据的分析
if reusltsheet.cells(r_riwindex,1) = "" then
' 给单元格填充颜色
end if
if reusltsheet.cells(r_riwindex,1) = "" then
' 给单元格填充颜色
end if
if reusltsheet.cells(r_riwindex,1) = "" then
' 给单元格填充颜色
end if
r_rowindex = r_rowindex + 1
end if
s_rowindex = s_rowindex + 1
loop
end sub