VBA fix data population

[Goes80]

Hi All
I'm new in this forum.
I have an excel situation that i'd like to ask.
assuming that i have a raw data as below

Lesson	Score	Student Name	Address	Phone Number		Student Name	Address	Phone Number
English	70​	Ali				Ali	Jakarta	9876543​
English	70​	Budi				Budi	Bandung	8765432​
English	70​	Dani				Dani	Surabaya	7654321​
Math	80​	Ali
Math	80​	Budi
Math	80​	Dani

i would like to create VBA button to populate the address and phone number based on the source data which is address and phone number.
in this button should be automatically populate only the address and phone number whenever i fill in new lesson and score, so the column of lesson, score and student name are manually entry but the vba button should only fill in the address and phone number column.

thank you for you support.
let me know if you have any concern for this question. thank you.

 

[alansidman]

With Power Query, Join the two tables with a Left Outer Join

let
    Source = Table.NestedJoin(Table1, {"Student Name"}, Table2, {"Student Name"}, "Table2", JoinKind.LeftOuter),
    #"Expanded Table2" = Table.ExpandTableColumn(Source, "Table2", {"Address", "Phone Number"}, {"Table2.Address", "Table2.Phone Number"})
in
    #"Expanded Table2"