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

AutoPopulate a table based on a drop down lis
School time table software free download full version - Download - Organisation and teamwork
Html table size to fit window - Guide
How to delete a row in a table in word - Guide
Screenshot excel table - Guide
Excel macro to create new sheet based on value in cells - Guide

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

How do I change a base location on Instagram?

help me to add particular cells

Facebook says that my email doesn't match my facebook email

Auto generate serial number in excel based on Column

Similar discussions

Subscribe To Our Newsletter!