how to update one excel workbook from another by VBA + vlookup or index and match formula

[m_vishal_c]

hi Everyone,

I have two different Excel Workbook i.e. WB1 and WB2. I need to update particular column in WB1 from WB2.

For example:- there are some common columns in both WBs (Sr no and Lifds Date). if I update Lifds date with same Sr No in WB2, then that date should be getting updated automatically in WB1 with same SR No. (like vlookup through).

is anyone can help me out.

heaps thanks in advance

 

[m_vishal_c]

is there any way to sort it out by vba code ?

hi is there anyone who can help me about this ? I need VBA code

heaps thanks