User Forms for excel

[Haidi]

Ive been asked to create a template that can create a form (pref. MSForms) in excel. Except what I want it to do is beyond my scope.
In Sheet2 i have a table with Key Performance Areas as the header and KPIs for those KPAs in the rows.
I need Sheet1 to generate a dropdown in B8 of all the KPA headers from Sheet2. I then need this selection from the dropdown to create a table further down the page of the KPA in the first row with the KPIs below. Every time I select a new item from the dropdown (great if it could also reset between selections) i need those associated KPA/Is to add to the bottom of the table.

I then need these 3 columns to generate the form. I assume I can do this via Excel online if the format is correct which i suspect it currently isn't. I did wonder if perhaps this is better in Word but I don't want to copy and paste answers at the other end.

 

[Michael M]

Have a look here for step by step instructions on creating UserForms

How to Create Excel UserForm for Data Entry

See how to create an Excel UserForm for data entry, with text boxes and buttons. Follow step-by-step videos, detailed notes with screen shots, free Excel workbook

www.contextures.com

And at the same site for dropdown lists

Excel Drop Down Lists - Data Validation

Easy steps to make drop down list wth Excel data validation. Show list of valid entries, reduce data entry errors. Videos, written notes, free workbook

www.contextures.com

 

[Haidi]

Have a look here for step by step instructions on creating UserForms

How to Create Excel UserForm for Data Entry

See how to create an Excel UserForm for data entry, with text boxes and buttons. Follow step-by-step videos, detailed notes with screen shots, free Excel workbook

www.contextures.com

And at the same site for dropdown lists

Excel Drop Down Lists - Data Validation

Easy steps to make drop down list wth Excel data validation. Show list of valid entries, reduce data entry errors. Videos, written notes, free workbook

www.contextures.com

Hi Michael,
thanks for your reply, I have had a look at the user forms and it doesn't quite do what I want it to. All I need is 3 drop down lists on sheet1, with the 3rd being a multi select, to autofill a table also on sheet 1 matching the criteria from a table on sheet 2. How would I go about this please? I think this should be quite simple but Im not having much luck.

 

[Michael M]

The dropdown instructions are in post #2....2nd link
If you need a dynamic dropdown, you would ned to use this.....

Easy Steps Excel Dependent Drop Down List Data Validation

Easy steps for Excel dependent drop down list. Conditional data validation based on other cell, Region/City. Videos, written steps, get free Excel file

www.contextures.com

 

[Haidi]

The dropdown instructions are in post #2....2nd link
If you need a dynamic dropdown, you would ned to use this.....

Easy Steps Excel Dependent Drop Down List Data Validation

Easy steps for Excel dependent drop down list. Conditional data validation based on other cell, Region/City. Videos, written steps, get free Excel file

www.contextures.com

Hmm no problem with the dropdowns, they are working and not dependent. However, they are used to select the lookup criteria for the table on sheet 2 to populate 2 columns in the table on sheet1, not populate their own table. I want a table generated from these dropdowns, not to use the dropdowns to create a list. You will need to explain your thinking in basic terms for me because , and I apologize, I might be missing some of your logic.

 

[Michael M]

Sounds more like you need a VBA solution....I don't have EXcel ATM, so hopefully someone can jump in and assist!!