James Niven
09-08-2013, 07:12 AM
Hello,
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.
Thanks
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.
Thanks