Hi everyone, I'd like to seek help from you guys in writing a VBA code to link up two Excel worksheets, which consist of relative large volume of data. Let's say the two data lists are in the forms of the following:

Sheet 1:
Customer Key, Account Number, Balance
ID001, AC001, $100
ID001, AC002, $30
ID002, AC006, $20
ID002, AC007, $0
ID003, AC010, $500

Sheet 2:
Customer Key, Bonus ID, Bonus Point
ID001, BB001, 240
ID001, BB002, 100
ID002, BB005, 320

The required output will be placed in the Sheet 3 and it will be look like this:

Sheet 3:
Customer Key, Account Number, Balance, Bonus ID, Bonus Point
ID001, AC001, $100, BB001, 240
ID001, AC001, $100, BB002, 100
ID001, AC002, $30, BB001, 240
ID001, AC002, $30, BB002, 100
ID002, AC006, $20, BB005, 320
ID002, AC007, $0, BB005, 320
ID003, AC010, $500
...

Can the final output be generated via writting an effective Excel VBA code?

Many thanks for your help in advance!