I have an existing macro that formats an excel spreadsheet into fixed width text file based on customer specs.
I need to add code to enter ZZ into dl_state column if driver lives in foreign country, except if it is Canada. For Canada the province code gets entered into the dl_state column for all provinces except Northwest Territories and Yukon. These get a ZZ.
What is best approach for this? I've attached spreadsheet with data(dummy data) and the macro.