Need help o creating a automatic Vlookup using macro

[akhil123]

Hello,
It will be very great full if anybody can help me on this.

I have 2 sheets ,1. Workbook a- will automatically generated on daily basis with status of servers and other bulk information. 2. workbook B - fixed sheet with our servers host name.
I wanted to perform a vlookup of workbookb.serverhostname in workbook of A range (E1:H1), and result the status with hostname in another workbook of c , or in any other sheet.

Can anyone help me on this .

 

[YasserKhalil]

Can you upload sample workbooks to illustrate your request?

 

[Hui]

Akhil

Firstly, Welcome to the Chandoo.org Forums

Also have a read of: http://forum.chandoo.org/threads/using-vlookup-in-a-macro.30812/
http://forum.chandoo.org/threads/using-vlookup-in-a-macro.30812/
Where this was discussed this afternoon

 

[akhil123]

A- Auto generated.xlsx :- Coulumn Marked yellow for range , Compare E column and H value need to copy to new workbook.
B- Server List .xlsx

 

[Shailender]

Hey @AKHIL, Could you please post the question clearly.

 

[akhil123]

I have 2 sheets ,1. Workbook a- will automatically generated on daily basis with status of servers and other bulk information. 2. workbook B - fixed sheet with our servers host name.
I wanted to perform a vlookup of workbook-b- serverhostname in workbook of A range (E1:H1), and result the status with hostname in another workbook of c , or in any other sheet.

 

[Shailender]

Hey Akhil, please find the attached excel sheet with the coding which you requested. Hope it is useful.