I done this using formulas in Excel and works fine. However, I'm
looking to easing myself into broadening my VBA knowledge. Wonder if
this is possible in Excel VBA?

I have a list(table 1) and I want to generate using Excel VBA the
remaining part of the table using excel VBA (see table 2).

Want some excel vba code to go through each record Payment field column
and fill in the Pay_Type, Area and Interest columns. Taking into
account that A_ID column is always blank.

The key for the Payment is:
Pay_Type Area Interest
M = Monthly A 10
S = Semi-Ann 3 30
Q = Quarterly DDE 25
D = Decade 10y 4
Y = Yearly 123 5

table1:
Customer Payment
1 M
20 M
17 S
3 M
4 S
15 S
5 S
70 Q
81 Y
9 Q
10 Q
34 Y
21 Y
6 Q
9 M

table 2
Customer Payment A_ID Pay_Type Area Interest
1 M Monthly A 10
20 M Monthly A 10
17 S Semi-Ann 3 30
3 M Monthly A 10
4 S Semi-Ann 3 3
15 S Semi-Ann 3 3
5 S Semi-Ann 3 3
70 Q Quarterly DDE 25
81 Y Yearly 123 5
92 Q Quarterly DDE 25
11 Q Quarterly DDE 25
34 Y Yearly 123 5
21 Y Yearly 123 5
6 Q Quarterly DDE 25
9 M Monthly A 10
10 S Semi-Ann 3 30
40 D Decade 10y 4
23 D Decade 10y 4

Is this doable in Excel VBA?

Apreciate your help on this matter.

Many Thanks and Kind regards

Brenda "XXX"