I assume you are an experienced coder, so:

Use the Change Event and cut the row to the "bottom of the spreadsheet"

See Chip Pearson's page on Events

http://www.cpearson.com/excel/events.htm

Just for interest -
bottom of spreadsheet is just that, the area
below items where there is not data.

to me, the bottom of a spreadsheet is Row 65536. That's why I asked.

--
Regards,
Tom Ogilvy



"Noel" wrote in message
...
Each item is a transaction, and bottom of spreadsheet is just that, the
area
below items where there is not data. A simple sort just doesn't work,
that's
all I see. I need to see the rest of the list and when an item is changed
to
"resolved" I need it to automatically move to the "bottom" of the
spreadsheet.

"Tom Ogilvy" wrote:

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.