Move entire row to the bottom if cell has value.

Greetings,

I have an ongoing database and would like to be able to move all the rows with a date to the bottom of the spreadsheet and the rows without a date to the top. The date is in column H. Below is the code I am currently trying to preform the necessary task. Any help is much appreciated.

Please Login or Register  to view this content.

I made the changes but it only moves the first row to the bottom. I would like the code to move every row with a date in column H to the bottom

I have attempted a few solutions but to no avail. Does anyone know what I am missing for every row with a date in column H to be moved to the bottom of the worksheet?

Attached is an example worksheet. In the Date Complete column I would like all the rows with a date complete to be at the bottom and ones without to be at the top of the worksheet.

If it is possible, sort your Data from low to high (A to Z).
Of course the cells that look empty need to be empty.

As a beginner starter, paste this demonstration to the (Sheet1) worksheet module :

PHP Code: 

Sub Demo1()
         Application.ScreenUpdating = False
    With Range("A8:A" & Me.UsedRange.Rows.Count).Resize(, Me.UsedRange.Columns.Count + 1).Columns
        .Item(.Count).Value2 = Me.Evaluate(.Item(8).Address & ">""""")
        .Sort .Cells(.Count), xlAscending, Header:=xlNo
        .Item(.Count).ClearContents
    End With
         Application.ScreenUpdating = True
End Sub 


Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

This works great is there a way to have the code run every time the date is changed using a userform. I tried inserting the code into the userform code shown below but that didn't do what I needed. I am trying to have the code automatically move that row of data to the bottom every time a tech fills out the date complete on the userform. Thanks for all the help I hope this isn't impossible.

Please Login or Register  to view this content.

If the userform changes the value of the cells H on the worksheet use a worksheet change event to trigger the code you have

Please Login or Register  to view this content.

I cant figure out where to put the line of code. Attached is a reduced version of my database with names and such removed. The worksheets are locked (pass: abc) and the userforms on the SOL page is used to fill the worksheets. The 'Look Up Order' userform is used to fill in the complete date on both SOL and Tool Room Sheet. On the tool room sheet I would like the rows sorted by if it has a date complete or not with the ones without a date on top. I do not want the data on the SOL sheet changed, which right now it is changing both. Any help would be greatly appreciated and thank you all for your continuing help.

I have posted one

My apologies the password is "help" for the VBA code