return specific values

[enas]

Hii every one .

I have a problem in creating a macro for return specific values
I have 2 sheets, the first one contains all the informatoin of 1000 servers, eg: server name, ip address, port# and so on. all of these information fall in one coulmn for all of the 1000 servers. " each server information begin with wideip {, and end with }}. the IP address begin with address word ".

In the second sheet I have around 500 server name, and I need to get the IP address for these servers from the first sheet.

This is the macro for the first entry only, bit i dont know how to make the loop and search for the ip address for those 500 server!!

[VBA]Sub Macro1()
Range("A2").Select
Selection.Copy
Sheets("3dns config").Select
Cells.Select
ActiveWindow.SmallScroll Down:=20
Range("A17088:A17112").Select
ActiveWindow.SmallScroll Down:=3
Application.CutCopyMode = False
Selection.Copy
Sheets("Load Balanced Names").Select
Range("E2").Select
ActiveSheet.Paste
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub[/VBA]



HELP ME PLEASE

[Bob Phillips]

Post your workbook.

[mohanvijay]

try vlookup function