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

thecabincrew

New Member
Joined
Oct 7, 2015
Messages
1
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 :)
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,212,933
Messages
6,110,752
Members
448,295
Latest member
Uzair Tahir Khan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top