What do you mean by items? What specifically are the items? What do you
consider the bottom of the spreadsheet - after any cells containing values?
By Field, do you mean a cell has the word resolved type in it.

It sounds like you have a database type layout where each row represents a
separate transaction. in one column you enter the word resolved for any
transaction that is completed and you would like all the resolved rows to be
moved to the bottom.

This could be done by sorting. (Data=Sort). Sort on the column that
contains the word resolve or a blank cell.


--
Regards,
Tom Ogilvy

"Noel" wrote in message
...
I have a spreadsheet with several hundered items that continues to be
updated. I am looking for a way to move items to the bottom of the
spreadsheet when a certain field is changed to "Resolved". I am not that
fimiliar with excel but was hoping someone here could help me or point me
in
the correct direction.