How to have excel notify when data entered needs flagging

[KarenNZ1]

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.

[FDibbins]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-form...d-content.html

Thread Closed.