Need Help for VBA code to auto generate tables

[Rishi_Yagna]

Type	Region
Type 1	US
Type 2	Canada
Type 3	Mexico
Type 4

<tbody>
</tbody>

Biometric Systems

Hi, I need some help in VBA code which can generate table using the above information.

For Example: I need here 4 tables:

Biometric Sytems Value in US by type

Type	Value
Type 1	xx
Type 2	xx
Type 3	xx
Type 4

<tbody>
</tbody>

And so on for Canada and Mexico

Thanks.