HI,

i have created a small invoice system in excel which you can create invoices, email , print and save invoices. i have also created an paid or unpaid invoices where the user when inputting data can choose the choice between yes invoive been paid or no the invoice has not been paid.

what i did not think afterwards what happends if the invoice is now been paid how can i get it to automatically change its value and get inserted into the paid section

any help will be appreciated

Thanks