Previous Topic Next Topic

AutoPopulate a table based on a drop down lis

Closed
Alex - 22 Apr 2010 à 13:41
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 28 Apr 2010 à 09:19
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 responses

Réponse 1 / 2
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
22 Apr 2010 à 14:00
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.
Réponse 2 / 2
Alex
26 Apr 2010 à 16:11
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 28 January 2010 Status Contributor Last seen 5 May 2022 766
26 Apr 2010 à 16:41
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
27 Apr 2010 à 12:34
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 28 January 2010 Status Contributor Last seen 5 May 2022 766
28 Apr 2010 à 09:19
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

WOW equipment return
aakash12345_0667 -
HelpiOS -

1 response
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
How to pull data from column based on multiple criteria?
Raj_2823 -
TrowaD -

3 responses
How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses