Vlookup with workbook in a same folder

mayaa_mmm

Board Regular
Joined
Jul 30, 2014
Messages
54
Office Version
2010
Platform
Windows
In the below workbook A, with file name starting MarkList_12_4_2020.xlsx and sheet name as file name in stored folder (C:/Desktop/Mark)
NameMarkClassGrade
John
50​
Post GraduateA
Peter
50​
PreschoolA
Andera100NurseryS


In the another Workbook B, is the fixed Existing report which is also stored in the same folder, which has extra columns

Need a VBA coding for
1.Post Graduate-Assign Austin in Reviewed by column
2. Preschool-Assign Victoria in Reveiwed by Column
3. Nursery -Assign Anglea in Reveiewed by Column
NameMarkReviewed byClassGrade
John
50​
AustinPost GraduateA
Peter
50​
VictoriaPreschoolA

Output of workbook B
1. Vlookup with Workbook A with Name and update the workbook B with not available record only. (in this case Andera is new record )
John and Peter should not update again the workbook B.

NameMarkReviewed byClassGrade
John
50​
AustinPost GraduateA
Peter
50​
VictoriaPreschoolA
Andera100AngelaNurseryB
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Lukasier

Board Regular
Joined
Dec 27, 2019
Messages
79
I have no idea what you want to be honest. You need to describe your problem a little more :)
 

mayaa_mmm

Board Regular
Joined
Jul 30, 2014
Messages
54
Office Version
2010
Platform
Windows
I have no idea what you want to be honest. You need to describe your problem a little more :)
Thank you for your quick reply

I need to vlookup the Workbook A for the Name column with workbook B Name column
stored in the same folder (C:/Desktop/Mark)

Workbook A (Report download from server which starts with Mark-04-02-2020.xlsx and worksheet name as Mark-04-02-2020 and Workbook B stored in both folder.

Need a Macro to do this vlookup and paste the not available Name in the Workbook B
 

Watch MrExcel Video

Forum statistics

Threads
1,102,345
Messages
5,486,317
Members
407,539
Latest member
ltwkuav

This Week's Hot Topics

Top