PDA

View Full Version : return specific values



enas
08-29-2010, 09:11 AM
:) 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!!

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



HELP ME PLEASE :(

Bob Phillips
08-29-2010, 10:45 AM
Post your workbook.

mohanvijay
08-30-2010, 01:22 AM
try vlookup function