View Full Version : What to do when Text is found in a row?

James Niven
09-08-2013, 07:12 AM

I have spreadsheets I receive monthly and wanting to convert them ready for import into Access, I am about there but one final step to handle as outlined below.

At present the aircrafts "Not Built" from this spreadsheet show under column H as "Not Built", I wish to handle these the following way. So, if column H (Operator) equals to “Not Built” in any row, then in column A do the following for that row:

- Grab Prefix value (Value entered in by user variable is uPrefix)
- Model Number 3uu (u is for Unknown model)
- Grab 6 digit CN from column B
- To form A3uu000206

If column H does not contain “Not Built” ignore and move on to next row.
I have attached the full code I have, but marked the portion I want to be modified.


James Niven
09-09-2013, 03:12 AM

Are my instructions not clear enough?