Hi again

My client is a chimney sweep and I take his bookings at my answering service using a spreadsheet. I send the following day's worksheets each night (copied and pasted into a new work book and sent as an email attachment) and he has a mail merge programme on his computer which allows him to send letters to the database of customers and also to print out his receipts for the next day from the fields in the work book.

We'd like to know how we can have a flag pop up that let's us know which customers were repeat no-shows or non-payers so that next year I don't book them.

Can you help us with this?

Cheers
Karen.