I'm looking to create a macro that will ask the user how many rows will be in the table (the columns will be fixed at say 6). From here, I want the macro to ask the user the values for column1row'x' , column2row'x' , column3row'x' , … and so forth - populating the table. I have a tad of experience with VB but I forget most of the required syntax.

Any help is appreciated!