ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Subject: If Statements (https://www.excelbanter.com/excel-programming/289496-subject-re-if-statements.html)

Mike Wilson

Subject: If Statements
 
Thanks for the response Henry.

It is UK postcodes I'm trying to check, I had thought on just reviewing
the column entry instead of validating the code. My lot have a tendenancy
to just use the initial 3 or 4 characters or leaving the entry blank. So
we don't usually see the problem until the mail merged letters have
printed off, usually up to 300 / day

So I suppose what I am trying to do is to flag the fields with the
invalid or missing entries.

Thanks for you help


Mike




All times are GMT +1. The time now is 01:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com