我有一份图书目录的excel表,我现在用查找方式找到了所有包含 "名著”的内容,有500多条,我要是一行一行复制到另一个excel表格中,这样做太没有效率了,我怎样才能把查找出来的内容选定,然后复制到另一个excel表格中
我的自动筛选是灰色的?怎么办
ç¨ä¸è½çvbaå¯ä»¥å®ç°ã举ä¾è¯´æã
æä¸ç奶ç«ï¼æ ¹æ®é奶çè®°å½æ°æ®åææ¯å¤©æ ¹æ®æ¯ä¸ªå®¢æ·çé奶履å表ã代ç å¦ä¸ï¼
Sub é奶履å表()
Const mYbook = "é奶履å表"
Dim MPATH As String
Dim I, J As Integer
Dim K1, K2 As Integer 'K1è®°å½æ¥è¡¨çè¡å·ï¼K2è®°å½æ¥è¡¨çåå·
MPATH = ActiveWorkbook.Path
MBOOK = ActiveWorkbook.Name
Set d = CreateObject("Scripting.Dictionary")
Sheets("é奶记å½").Select
I = 2
Do While Len(Cells(I, 2)) > 0
c = Cells(I, 2)
If Not d.Exists(c) Then
d.Add c, Cells(I, 3)
End If
I = I + 1
Loop
I = I - 1
II = Trim(Str(I))
Dim BHK
Dim BH As String
Workbooks.Open Filename:=MPATH & "\" & mYbook
Sheets("æ¥è¡¨").Select
Columns("A:AE").Select
Selection.ClearContents
Windows(MBOOK).Activate
K1 = 1: K2 = 1
For Each BHK In d.keys
Set cOnn = CreateObject("ADODB.Connection")
Set RST = CreateObject("ADODB.Recordset")
cOnn.Open "dsn=excel files;dbq=" & ThisWorkbook.FullName
BH = BHK
Sql = "SELECT `é奶记å½$`.订奶ç¼å·, `é奶记å½$`.客æ·çµè¯, `é奶记å½$`.客æ·å§å,`é奶记å½$`.ååå称, `é奶记å½$`.æ¥æ, `é奶记å½$`.æ°é "
Sql = Sql & "FROM `é奶记å½$` `é奶记å½$` "
Sql = Sql & "WHERE (`é奶记å½$`.订奶ç¼å· =" & "'" & BH & "'" & ") "
Sql = Sql & " ORDER BY " & " `é奶记å½$`.æ¥æ "
RST.Open Sql, cOnn, 1, 1
Windows(mYbook).Activate
If Not RST.EOF Then
Cells(K1, 1) = RST.FIELDS(0)
Cells(K1, 5) = RST.FIELDS(1)
Cells(K1, 10) = RST.FIELDS(2)
End If
Do While Not RST.EOF 'å°é货记å½å¡«å ¥é奶履å表ä¸
Cells(K1 + 1, K2) = RST.FIELDS(4)
Cells(K1 + 2, K2) = RST.FIELDS(5)
RST.MoveNext
K2 = K2 + 1
Loop
K1 = K1 + 4
K2 = 1
RST.Close
cOnn.Close
Set RST = Nothing
Set cnn = Nothing
Next BHK
End Sub
é奶记å½è¡¨æ ¼å¼å¦ä¸å¾ï¼
é奶履å表ï¼å¦å¾ï¼