Forum Discussion
cak980
May 05, 2022Copper Contributor
Using VBA to move a range of data to a different sheet when complete (need the for dummies version)
I'm trying to setup a macro so that when a task is completed (indicated with X), it automatically gets moved to a separate tab and deleted from original location. I was able to accomplish this but it moved the entire row. I'm trying to move a range of data, not the entire row. Thanks!
25 Replies
Sort By
What is the code you're using now?
- cak980Copper ContributorSub move_rows_to_another_sheet()
For Each myCell In Selection.Columns(4).Cells
If myCell.Value = "Closed" Then
myCell.EntireRow.Copy Worksheets("Sheet2").Range("A" & Rows.Count).End(3)(2)
myCell.EntireRow.Delete
End If
Next
End Sub- Rajesh950Copper Contributor
hi team
i need a code in which i can move my cells data to another sheet ,
like i have data in cells A to I
and if i write c in cell I1 then it should move data from cell A to I into another worksheet
thanks