I would post this in the programming forum.

But what you can do is just create the most basic macro that sorts a
sheet by a specific column. So that after you fill out the forms you
can just run the macro quickly and push the empty rows to the bottom.
Then delete them.

Maybe not the best answer, but it will work.


--
Backdoor Cover
------------------------------------------------------------------------
Backdoor Cover's Profile: http://www.excelforum.com/member.php...o&userid=19842
View this thread: http://www.excelforum.com/showthread...hreadid=376080