How to Automate this Sorting Proceedure

[SEMME]

A .. B . C .. D
0 .. 27 . 1 .. 18
0 .. 16 . 0 .. 27
1 .. 18 . 1 .. 23
1 .. 23 . 0 .. 16
0 .. 32 . 1 .. 9
0 .. 33 . 0 .. 32
1 .. 9 . 1 .. 5
1 .. 5 . 0 .. 33
0 .. 25 . 1 .. 15
0 .. 35 . 0 .. 25
1 .. 15 . 1 .. 30
0 .. 4 . 0 .. 35
0 .. 28 . 1 .. 1
1 .. 30 . 0 .. 4
1 .. 1 . 1 .. 3
1 .. 3 . 0 .. 28
0 .. 13 . 1 .. 20
0 .. 11 . 0 .. 13
1 .. 20 . 1 .. 31
1 .. 31 . 0 .. 11
1 .. 14 . 1 .. 14
1 .. 10 . 0 .. 34
0 .. 34 . 1 .. 10
0 .. 17 . 0 .. 17
0 .. 22 . 1 .. 21
0 .. 24 . 0 .. 22
1 .. 21 . 1 .. 2
0 .. 26 . 0 .. 24
0 .. 12 . 1 .. 8
0 .. 6 . 0 .. 26
1 .. 2 . 1 .. 29
1 .. 8 . 0 .. 12
1 .. 29 . 1 .. 7
1 .. 7 . 0 .. 6
1 .. 19 . 1 .. 19


Hello Board Members,

Column A contains a string of binary numbers (1's & 0's ) that are formula generated with
an associated formula generated number in column B.

I want (excel 2003) to list for me in column D the associated number in column B that corresponds to the binary formation in column C: where the first "1" in column A is the number 18, so D2 shows 18. Next the first "0" in column A is the number 27, so D3 shows
27...next the second occurance...so on and so forth.
If I change the formation in column C, then excel would reflect the results.

I'm doing this manually, sort, copy and pasting humdreds of times per session.
I'm hoping you could help me automate this proceedure.

Thank you in advance,
SEMME

 

[SEMME]

Sorry just to clarify, above I wrote that I am manually sorting etc, actually I'm already using a macro, so by automate I mean to say that excel will show results "live", or on the fly for lack of a better word...thanks