Good Afternoon All,
I am trying to automate a task to take data from one column and copy a district identifier to another. The data and the expected outcome are below.
<colgroup><col><col></colgroup><tbody>
</tbody>
I can easily pull data from the first few rows using Mid, but I have three different scenarios to look at and the amount of data in the sheet is variable.
Any assistance with this is greatly appreciated.
Dan
I am trying to automate a task to take data from one column and copy a district identifier to another. The data and the expected outcome are below.
District | Output |
Congressional District 1 | 1 |
Congressional District 2 | 2 |
Congressional District 3 | 3 |
Congressional District 4 | 4 |
Congressional District 5 | 5 |
State Senate District 21 | 21 |
District 21 | 21 |
District 30A | 30A |
District 30B | 30B |
District 31A | 31A |
5th Judicial Circuit | 5 |
5th Judicial Circuit | 5 |
Legislative District 21 | 21 |
<colgroup><col><col></colgroup><tbody>
</tbody>
I can easily pull data from the first few rows using Mid, but I have three different scenarios to look at and the amount of data in the sheet is variable.
Any assistance with this is greatly appreciated.
Dan