moving completed cells to the bottom of a spreadsheet

[kat0520]

I know there is probably a very simple macro for this but everything I keep trying is not working. I am using excel 2013 and am having difficulty recording a macro that will move rows of completed work to the bottom of my call tracker tracker spreadsheet. I have a list in column that we fill in once completed. Once I complete a task I'd like it's entire row B:J to move to the bottom. I know I am over thinking this but I can't get anything to work.

 

[John Davis]

Maybe:

Sub kat0520()
Range(Cells(ActiveCell.Row, "B"), Cells(ActiveCell.Row, "J")).Copy Sheets("call tracker tracker").Range("B" & Rows.count).End(3)(2)
Range(Cells(ActiveCell.Row, "B"), Cells(ActiveCell.Row, "J")).Delete
End Sub

 

[XLfriend777]

Hi Kat0520 - Just a thought. Rather than moving the completed rows, have you thought of just filtering on all those that are not complete, leaving just the ones you want to view? Sort can also do this if you mark the ones that are complete. Hope this helps.

 

[kat0520]

Hi Kat0520 - Just a thought. Rather than moving the completed rows, have you thought of just filtering on all those that are not complete, leaving just the ones you want to view? Sort can also do this if you mark the ones that are complete. Hope this helps.

Yes, but this spreadsheet is going to be used by multiple users and would like it to update automatically based on the information inputted in the spreadsheet.

 

[problemss]

I would do the sorting like goesr said. If you want it to auto update here is a quick way.

http://www.mrexcel.com/forum/excel-questions/794814-wondering-if-could-done-2.html

Look at post #12 and pull the function Private Sub Worksheet_SelectionChange(ByVal Target As Range) Make this function do a refresh on the table you are editing.