Ok to start I made a spred sheet in excel 2008 of the bills i have to pay with 4 colloms : payee, when its due, how much to pay, and is it payed.
the last collom (is it payed) is a drop box with yes no or ?,

what i would like to do is when i select yes in that last collom that row will go to another area on the spred sheet with the title payed bills

is there any way to do this automaticly when yes is selected with out copy and paste ?

thanks for any help you guys and gals can offer