VBA to use Vlookup on another spreadsheet.

[ManxBen]

Hi All

Looking for some help with a VBA code.

Each day I get 2 reports generated from different systems.

The first shows the current status of orders and the second shows whether money has been received.

The first spreadsheets data looks like:

Name	Date	Status	Order Number
Tim	01/11/2016	Pending payment	111111111
James	15/11/2016	Pending payment	222222222
Sam	17/11/2016	Pending payment	333333333
Leah	20/11/2016	Pending payment	444444444
Luke	21/11/2016	Pending payment	555555555
Paul	21/11/2016	Pending payment	666666666

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

The Second reports data looks like

Order Number	Currency Received	Amount Received	Date received
222222222	GBP	1000	20/11/2016
444444444	EUR	1200	21/11/2016
666666666	USD	999.99	21/11/2016

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

I would like to add a VBA code to the first spreadsheet to use a Vlookup to source data from the second Spreasheet to identify where funds have been received.

The second spreadsheet is saved within C:\Users\John\Documents\Payment Report.xlsx

Could someone assist me in how to I add a Vlookup to column E, F and G to return the Currency, Amount and date from the Payment Report. if the Order number is on both reports.

This will also need to go to the last row of data so if you could include this that would be great.

Thanks
Ben

 

[Rijnsent]

Hi Ben,
how far did you get with formulas/recording a macro? Please do post your code here (in [ CODE ] brackets), so we can give you some feedback.
Cheers,
Koen