I have a spreadsheet which is daily updated with a list of companies at different states of bankruptcy (`**text**`). These status can vary and new ones can be added.

What the macro has to do is fill the `column A` with the current bankruptcy status of the company, and delete it from `column B`. An example, before:

```
column A    column B
            **Bankruptcy Required**
            Company 1
            Company 2
            Company 3
            **Bankruptcy Decreed**
            Company 4
            Company 5
            **Extinct Bankruptcy Process**
            Company 6
            **Required Reorganization**
            Company 9
            Company 10
            Company 11
            **Judicial Recovery Upheld**
            Company 12
            Company 14
            Company 15
            Company 16

```

After:

```
column A                          column B
Bankruptcy Required               Company 1
Bankruptcy Required               Company 2
Bankruptcy Required               Company 3
Bankruptcy Decreed                Company 4
Bankruptcy Decreed                Company 5
Extinct Bankruptcy Process        Company 6
Required Reorganization           Company 9
Required Reorganization           Company 10
Required Reorganization           Company 11
Judicial Recovery Upheld          Company 12
Judicial Recovery Upheld          Company 14
Judicial Recovery Upheld          Company 15
Judicial Recovery Upheld          Company 16

```

Any ideas?