I'm working on a project that has a data table with 10 columns and a variable amount of rows. The first column 'A' title is "Case" and the inputs in this column are unsorted. I have column 'X' which has the inputs in the right order. Columns 'B' thru 'J' are based on column 'A'. I'm looking for a way to sort column 'A' based on column 'X'.

input looks like this for example : 

```
C4
C1 
C11
W36
W39
C21

```

And it needs to look like this:

```
W36
W39
C1
C4
C11
C21

```

Any help with the vba code would be useful. I'm fairly new to programming.