dynamically insert columns to a table using excel macros

[air_vignesh]

Hi,
Total newbie..please help
I need to dynamically insert columns into table B based on the count of the number of rows in table A using macros

As in,
INITIALLY...
Table A
123
234
456

(count =3)
So on clicking of a button submit.. TABLE B with 3 columns should be created..
Now if i add another row in TABLE A..

Table A
123
234
456
789

Now when i click submit a 4th column should be added in the table.

Please help.

Thanks,
Vignesh