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


New Member
Oct 7, 2015
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.


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 :)

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...