Hello

I am trying to create a simple table, with condition, but having a hard time. Let me explain

I just created a table with 2 columns and 14 rows (B2:C15). On top of the table, I have a single column field (B1) that enables users to enter a specific amount of number. What I want is the table I created, (B2:C15) should replicate according to the amount of number entered in field B1. For an example, if you enter, 4 in column B1, the table should replicate 4 times, either vertically or horizontolly, preferably with one column or row left blank in between the tables.

Can someone please help me... I am not sure... I am using excel 2007..