Excel 2007 : Auto-populate cells based on value in another cell

**dnice24** · 11-30-2010, 12:09 AM

I'm creating a configuration tool for instrumentation that has several options. Many of these options are dependent on one another. I have extinguished all my options in non-VBA land, so I need some help. To summarize, I need to:

*Conditionally lock cells (and populate with "N/A") OR allow selection from drop down list - the list exists, it's the locking and auto-population I'm struggling with

Example:
If A1 = No, then B1 = "N/A" and is locked, else allow selection from drop down list in B1

A simple macro example that does this would really help. I will be able to adjust ranges, values, etc. Thanks in advance for any assistance...

**DonkeyOte** · 11-30-2010, 04:19 AM

Originally Posted by dnice24

If A1 = No, then B1 = "N/A" and is locked, else allow selection from drop down list in B1

Modifying the "constant" in B1 per A1 selection would as you say require VBA.

If on the other hand you're just happy to prevent selection from the DV List then you could modify the source of the List accordingly, eg:

Please Login or Register  to view this content.

In this way when A1 is No the List can't be selected - avoids VBA obviously - but does not clear B1 and replace with Error Value.
If you're truly desperate for VBA (to generate in cell value) let us know.

**dnice24** · 11-30-2010, 02:31 PM

Elegant solution... much appreciated!

**jlarkin@balcrank.com** · 04-29-2014, 03:03 PM

I am looking or a solution to populate my quote sheet using data with a quantity over 0, with out leaving blank rows between the resulting data.

example
tab name "budgetary quote" A16 has a quantity of 2 should = to tab name "final quote" A16 -entire row populates. However rows 17-19 have zero quantity so nothing is populated on "final quote." tab name "budgetary quote" A20 has a quantity of 4 should = to tab name "final quote" A17 -entire row populates.

I hope that makes sense. In the end I want a clear quote I can print for the customer.
Thank Jess