lookup next value in column

[fiur]

this is my problem

1.............. A..............B..............C............. D..............E
2.............. test1........................................ test1.........350
3.............................................................. test2........ 475
4.............. 350...........................................test3........ 550
5.............. test2..............................................................
6....................................................................................
7.............. 475................................................................
8.............. test3..............................................................
9...................................................................................
10............ 550...............................................................

what I wanna do is to get the number below "test1" in (in row A) into the cell next to test1 in column E (and so on for test2 and 3....
hope hope you understand my question (english is not my native language...)

[mrice]

The macro should work.

Please Login or Register  to view this content.

Open up the VBA editor by hitting ALT F11

Insert a new module by hitting Insert - Module

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007.

[fiur]

thank you alot for the reply and it works like a charm !
but I got another problem here...
where the value is listet it show like this: [463 pts] is there anyway to get rid of the [ and pts..] so only the value is left??

[pike]

What code fiur?

[mrice]

Maybe this?

Please Login or Register  to view this content.

[fiur]

Maybe this?
yes thanks alot just what I needed thank you all for yours replies