Palon
11-16-2014, 03:03 PM
Dear All,
Please see below (treat __ as space):
| NO-6514 rs,soKristiansund__ | __________|
| Aspx CH-1024 Ecublens____ |Switzerland_ |
| CH-1009 Ajuhal Pully ______ |___________|
| Sumthin DK-3660 Stenløse_ | Denmark__ |
| Himmhs AT-4724 Neukirchen |__________ |
| Trololo NL-8442 BZ HEE____ | Netherlands |
| AT-3500 Krems Smpffr_____ |__________ |
What I am trying to overcome is making a fragment of a code that does the following:
1. Out of a single column with different text values - select only cells with no value (blank)
2. Select cells with offset (0, -1) to each cell selected in 1.
3. See if cells selected in 2. contain a phrase eg. "AT-" (data in cell would contain several alphanumerical words).
4. For every selected cell in 2. which meets condition in 3. - input text value eg. "Austria" into corresponding blank cell from 1.
offset ( 0, +1)
In short - I want the code to look up blanks and fill them in with country name. Only for "AT-" and "Austria".
Help is deeply appreciated. Thank you.
Please see below (treat __ as space):
| NO-6514 rs,soKristiansund__ | __________|
| Aspx CH-1024 Ecublens____ |Switzerland_ |
| CH-1009 Ajuhal Pully ______ |___________|
| Sumthin DK-3660 Stenløse_ | Denmark__ |
| Himmhs AT-4724 Neukirchen |__________ |
| Trololo NL-8442 BZ HEE____ | Netherlands |
| AT-3500 Krems Smpffr_____ |__________ |
What I am trying to overcome is making a fragment of a code that does the following:
1. Out of a single column with different text values - select only cells with no value (blank)
2. Select cells with offset (0, -1) to each cell selected in 1.
3. See if cells selected in 2. contain a phrase eg. "AT-" (data in cell would contain several alphanumerical words).
4. For every selected cell in 2. which meets condition in 3. - input text value eg. "Austria" into corresponding blank cell from 1.
offset ( 0, +1)
In short - I want the code to look up blanks and fill them in with country name. Only for "AT-" and "Austria".
Help is deeply appreciated. Thank you.