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

 

[FDibbins]

If you only want to update 1 WB from the other 1, a regular vlookup should work for you - have you tried that yet?

 

[m_vishal_c]

If you only want to update 1 WB from the other 1, a regular vlookup should work for you - have you tried that yet?

hi
Thanks for replying. yes I can do that way but i want to be happned automatically. instead of applying manual vlookup

 

[FDibbins]

vlookup is not manual, once you have it working, it will reference the source file and change every time the source file changes

 

[m_vishal_c]

vlookup is not manual, once you have it working, it will reference the source file and change every time the source file changes

hi, its huge data and vlookup stuck and takes too much time to get refreshed . so I need vba code

thanks

 

[FDibbins]

How big is huge, and what does your formula look like?

 

[m_vishal_c]

How big is huge, and what does your formula look like?

its 55125 rows and 91 columns. I use normal vlookup formula (=vlookup(ref, range,ref no, 0)

 

[FDibbins]

Show your actual formula plz

 

[m_vishal_c]

Show your actual formula plz

=VLOOKUP(C3,'ABC '!$C$2:$F$55125,4,0)

I need vba code only

 

[m_vishal_c]

=VLOOKUP(C3,'ABC '!$C$2:$F$55125,4,0)

I need vba code only

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