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