Userform To Fill Duplicate Rows

CantGetRight

New Member
Joined
Jul 21, 2015
Messages
21
Hello there,

I need multiple users in various Fantasy groups to populate a worksheet for me. I don't want the exercise to be cumbersome, hence a Userform. I need to achieve the following:

User Selects their group (sample options below):
Fantasy Group 123
Fantasy Group 1234
Fantasy Group 12345

Each group then has people that belong to it in multiple cities (NY, Hong Kong, Tokyo) AND also different age ranges (18-25,26-40,40+). I want one single option at the top to select group and then below to have the fields in bold/underlined next to an input box where you enter a number. If 1 is entered next to "NY" & "18-25", then a single row will populate in a spreadsheet that has the following:


[TABLE="width: 203"]
<tbody>[TR]
[TD]Group[/TD]
[TD]City[/TD]
[TD]Age Ranges[/TD]
[/TR]
[TR]
[TD]Fantasy Group 123[/TD]
[TD]NY[/TD]
[TD]18-25[/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]


If the user enters 15 next to that same field, I want it to duplicate the row 15 times.

On top of this, because I want each field being visible on the userform, I'd like if the person could select different cities/age ranges and also the ability to select the same city with different ages and all of this to translate to the worksheet in one userform.

Is this possible and is it possible to provide a sample workbook so I can test it as my experience with userforms is limited.

I am trying to include an image of a Userform I created as a mockup but it needs it to be a URL. Any guidance on how to upload this would be great.

Thanks in advance.

Best,
CantGetRight
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

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