I have a list in excel that is automatically populated. In column A I
have values like:

A1: Test_2006_17_1
A2: _2
A3: _3
A4: _4
A5: Test_2006_18_1
A6 _2
A7 _4
A8 _5
A9 Test_2006_19_2
A10: _7
A11: _9

1.What I need is a vb script that runs through the values in columns A
2.Looks for a value that does not start with "Test" (in this case the
first value to be found will be _2), goes 1 cell up until the cell is
found which starts with Test
3. change the value (in this case _2) with the value that has been
found in step 2 while deleting the last 2 positions (in this case _1).
The result in cell A2 will be Test_2006_17_2, in cell A3 Test_2006_17_3
etc.

Should be simple, but my vba knowlegde does not go that far
unfortunately.