What I have is a place in a spreadsheet for people to put
in action items and a complete date (I know, there are
much better tools for this, but this is the tool they want
to use). If there is a completion date (i.e. it isn't
blank) then I want to move that entry down to a separate
section containing completed actions.

My thought was to write a macro that checked each cell for
a completed date and if it contained an entry to simply
cut and paste it onto the end of the list at the bottom.

Thanks for your help.

Bob






-----Original Message-----
Hi,

I want to run a macro that simply moves data from one row
to an area of the worksheet that keeps track of completed
items. What I need is a statement that does something
like this:

=IF(b1="",do nothing, run move macro).

How do I tell the =IF function to run the macro? This
seems to be a pretty easy thing to go yet the Help does
not address it.

Thanks,

Bob
.