Previous Topic Next Topic

AutoPopulate a table based on a drop down lis

Closed
Alex - Apr 22, 2010 at 01:41 PM
rizvisa1 Posts 4478 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

Related:

2 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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.
Answer 2 / 2
Alex
Apr 26, 2010 at 04:11 PM
https://authentification.site/files/22144510/Sample_test.xls

I have uploaded a sample sheet at the following link.

Kindly please advice.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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 ?
Alex
Apr 27, 2010 at 12:34 PM
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
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
WOW equipment return
aakash12345_0667 -
HelpiOS -

1 response
How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses