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

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...