- 重用任何东西： 将最常用或最复杂的公式，图表和其他任何内容添加到您的收藏夹中，并在将来快速重复使用它们。
- 超过20文本功能： 从文本字符串中提取数字; 提取或删除部分文本; 将数字和货币转换为英语单词...
- 合并工具：多个工作簿和表格合二为一; 合并多个单元格/行/列而不丢失数据; 合并重复行和总和...
- 拆分工具：根据价值将数据拆分为多个表格; 一个工作簿到多个Excel，PDF或CSV文件; 一列到多列......
- 粘贴跳过 隐藏/过滤行; 数和总和 按背景颜色; 创建邮件列表和 通过Cell的价值发送电子邮件...
- 超级过滤器： 创建高级过滤方案并应用于任何工作表; 排序 按周，日，频率等; 筛选 通过大胆，公式，评论......
- 超过300强大的功能; 适用于Office 2007-2019和365; 支持所有语言; 在公司轻松部署; 全功能60天免费试用。
1。 按 其他+ F11 键同时打开 Microsoft Visual Basic for Applications 窗口。
2。 在里面 Microsoft Visual Basic for Applications 窗口中，单击 插页 > 模块。 然后将下面的VBA代码复制并粘贴到窗口中。
Sub MoveToEnd() Dim xRg As Range Dim xTxt As String Dim xCell As Range Dim xEndRow As Long Dim I As Long On Error Resume Next If ActiveWindow.RangeSelection.Count > 1 Then xTxt = ActiveWindow.RangeSelection.AddressLocal Else xTxt = ActiveSheet.UsedRange.AddressLocal End If lOne: Set xRg = Application.InputBox("Select range:", "Kutools for Excel", xTxt, , , , , 8) If xRg Is Nothing Then Exit Sub If xRg.Columns.Count > 1 Or xRg.Areas.Count > 1 Then MsgBox " Multiple ranges or columns have been selected ", vbInformation, "Kutools for Excel" GoTo lOne End If xEndRow = xRg.Rows.Count + xRg.Row Application.ScreenUpdating = False For I = xRg.Rows.Count To 1 Step -1 If xRg.Cells(I) = "Done" Then xRg.Cells(I).EntireRow.Cut Rows(xEndRow).Insert Shift:=xlDown End If Next Application.ScreenUpdating = True End Sub
3。 按 F5 运行代码的关键，然后在弹出 Kutools for Excel 对话框中，选择某个值所在的列范围，然后单击 OK 按钮。
点击后 OK 按钮时，指定列中包含值“完成”的整行将自动移至数据范围的底部。
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 1 months agoHello, the only way I can get this to work is if I "run" the macro in the Visual Basic sub screen. Is it possible to have this VBA code run automatically, once the user types in "Done"? Each time I'm getting the Kutools for Excel dialog box pop up to ask the parameters I'm requesting the code to search by. I have sort of worked around this by replacing : xTxt = ActiveSheet.UsedRange.AddressLocal with the parameters I need searched and hitting enter. But it would be more convenient if it automatically made the changes after "Done" was entered. Thank you!
To post as a guest, your comment is unpublished.· 3 months agoHello, is there a way to tweak this so that it moves a row somewhere else in the same sheet besides the end? I have a sheet that has order information for dated orders and upcoming orders yet to be dated and I have it so that when I put an "X" in column A things highlight and bold depending on part #'s and shipping locations. Now I have to physically cut and paste the newly dated (shipping date) so that it fits in at the top sorted by date (1st thru end of month). I have been able to conditional format everything up to this point, but I don't think I can move rows that way. I was wondering if VBA could do this, move a row when a date is entered to fit in with the other dated rows?
To post as a guest, your comment is unpublished.· 8 months agoHello. This is almost perfect for what I want. I have part of the same request as Anon had to make this work without user input along with some extras.
I am wondering if it is possible to have the only column searched to be i4 to i50 and have it automatically run at open or anytime the i column is edited. Also if it would be possible to move the rows to the bottom of the sheet without any blank rows between "done" rows and "no" rows. Currently if I select i4:i50 and if I only have data up to row 25 it will paste the "done" rows ascending from row 50 instead of row 25. The number of rows in my sheet is constantly changing and shouldn't get to more than 50. Thanks for the help.
To post as a guest, your comment is unpublished.· 1 years agoHi Crystal, this code works great, thank you. I would like move all the rows which contain word "Complete" in column D to the top of the table (insert in row 3). Is that possible? then I would like to delete all these complete rows which contain "yesterday date" in column V.
To post as a guest, your comment is unpublished.· 1 years agoHow could I make it so the kutools selects specific rows without user input?