AutoPopulate a table based on a drop down lis

Closed
Alex - Apr 22, 2010 at 01:41 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Apr 28, 2010 at 09:19 AM
I have defined a drop down menu list and I am trying to get microsoft excel to auto populate a table/form to enable one to input some data.

For eg: If Drop Down list contains elements: (Preparation, Marination, Cooking, Garnishing)

I click on Preparation and I want excel to Auto Generate a table (5 rows) for the following items (each element within <> refers to an adjoining column)

Ingredients
<s.n.> <name of ingredient> <units> <Measure>

If some one could help me with a solution, it would be well appreciated

2 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Apr 22, 2010 at 02:00 PM
Could you please upload a sample file on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.
0
https://authentification.site/files/22144510/Sample_test.xls

I have uploaded a sample sheet at the following link.

Kindly please advice.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Apr 26, 2010 at 04:41 PM
So what happens if I initially select "Cooking" and then fill the table and then realized I meant preparation, so what about the table that was generated and filled earlier ?
0
I dont know.

Can we have a caution statement/checkbox which provides the option of either removing or keeping the data in the box?

Kindly advice
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Apr 28, 2010 at 09:19 AM
The more I see you sample, the more I get confused. To keep every thing very simple, would it not be easy to have some thing like this

https://authentification.site/files/22170458/Sample_test.xls
0