how to copy data from two excel workbooks into third. merging data based on common field

[shilpa2002]

Hello all,

how to do I merge data from two excel workbooks into third using vbscript based on a common field .
.

 

[SkipVought]

Much too vague.

What happens in vagueness, stays in vagueness.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

 

[shilpa2002]

just want to know how to apply vlookup using vbscript. Already doing this using vlookup. But since number of files increasing, using vlookup becoming a lot cumbersome and confusing.

 

[SkipVought]

Still too vague.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!