JohnBradley
09-14-2014, 01:19 AM
Hi guys,
I need help about vlookup vbs code, please help if you could...
The vba code need to call table from external file and represent results in current file.
To be more specific –
I have an excel file (1) that has numbers in column A something like that:
COLUMN A
3232134
4563455
6565656
I have a second excel file (2) in my PC in this path W:\Documents\Files his name is "compare" that also with my (1) file numbers in column A and other serial of numbers in the same rows but column B, something like that:.
COLUMN A COLUMN B
3232134 1111111
4563455 2222222
6565656 3333333
From him I need to create a vlookup what will compare and push these numbers of file (2) column B to file (1) column A
Thanks in advanced.
John.
I need help about vlookup vbs code, please help if you could...
The vba code need to call table from external file and represent results in current file.
To be more specific –
I have an excel file (1) that has numbers in column A something like that:
COLUMN A
3232134
4563455
6565656
I have a second excel file (2) in my PC in this path W:\Documents\Files his name is "compare" that also with my (1) file numbers in column A and other serial of numbers in the same rows but column B, something like that:.
COLUMN A COLUMN B
3232134 1111111
4563455 2222222
6565656 3333333
From him I need to create a vlookup what will compare and push these numbers of file (2) column B to file (1) column A
Thanks in advanced.
John.