User input in a column, and creating option to select how many rows it will populate

[thecabincrew]

Hello Community,

I am seeking the advice of any advanced users in my attempt to create an efficient user input, data entry form for the creation of table metadata.

Scenario

I am looking to design my sheet/Macro with the top two rows as user inputs, which will then paste these into a table.

So: A1= System Name, A2= Schema Name

There would then be an option asking how many rows you would like these inputs populated to. The user would enter a number, and it would automatically populate, or I assume I would create a command button to execute this function.

The columns of the table just in case are:
- ID
- System Name
- Schema Name
- Table Name
- Attribute Name

The columns in bold are the values I would want to auto-populate based on the user entry.

The remaining columns can actually be filled in with dummy data, so if there is an additional feature anyone can think of to take care of this, that would be great as well.

Thanks for taking the time to read through my request

 

[portews]

Hmmmmm. Adept?

Take a look at this post, it sounds very similar:

http://www.mrexcel.com/forum/excel-...s-auto-fill-column-name-based-cell-value.html