因為有大量的資料長得跟A到D攔差不多
想變成跟F攔一樣
有辦法用快速的方法嗎?
excel 問題大量資料處理?
回答 (1)
2020-07-30 10:21 am
sub test()
dim Cx,k,i,j as long
Cx=activesheet.usedrange.columns.count
k=1
for i=1 to Cx
for j=1 to cells(1048576,i).end(3).row
cells(k,Cx+2)=cells(j,i)
k=k+1
next j
next i
end sub
dim Cx,k,i,j as long
Cx=activesheet.usedrange.columns.count
k=1
for i=1 to Cx
for j=1 to cells(1048576,i).end(3).row
cells(k,Cx+2)=cells(j,i)
k=k+1
next j
next i
end sub
收錄日期: 2021-05-03 06:49:41
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20200729162038AAcvZjm