I need an Excel coder to do the following 2 tasks:
1.) I have a spreadsheet (Excel2003) that contains a cell that needs it’s contents validated. The user will be entering a National Health Index (NHI) number which is a unique 7 character identifier which consists of 3 alphabetic and 4 numeric characters. The NHI number needs to be validated against the following routine mentioned on this site:
http://www.nzhis.govt.nz/moh.nsf/pagesns/276?Open
2.) On the same spreadsheet I have a number of drop down lists where the user can select a value. At the moment the drop down list shows values such as ‘T10 – Support needs assessment attendances’. What I want is after the user makes a selection it will show just the T10 back in the cell rather then the full description.
Will send the winning bidder a copy of the spreadsheet.
