Need to auto-populate cells "N/A" when selecting from a drop-down list.

**dpeek** · 01-08-2016, 04:08 PM

Right now, nothing happens to the cells if you change the drop-down selection. My thoughts and hopes would be if you did select a number, specific cells would fill in N/A. (I added conditional formatting to have that cell turn grey if an N/A is present).
So if my vision can work...if I were to change the number from 2 to a 3, the N/A's would change accordingly.

About the merged cells...I can't just expand a column because it would mess with my formatting on the entire page. I have a bunch of data entry forms above and below the section I posted here. And expanding would distort everything else.

**zbor** · 01-08-2016, 04:11 PM

If you change from 3 to 2 it will just add N/A into some cells.
But when you change 2 to 3 some N/A will be removed.
What will happen with those cells? Blank? Some formula? Some value?

**tony h** · 01-08-2016, 04:42 PM

I can put together some VBA to:
1. on change of dropdown -clear the old N/As and set the new N/A
2. I could colour the cells accordingly as part of the VBA or leave that to your conditional formatting

Obviously:
1. if the new drop down value causes N/A in new cells the old values will be lost
2. if N/A are cleared from some cells they will be blank

doing this in VBA will allow values to be overtyped

Need to auto-populate cells "N/A" when selecting from a drop-down list.

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Need to auto-populate cells "N/A" when selecting from a drop-down list.

Re: Need to auto-populate cells "N/A" when selecting from a drop-down list.

Re: Need to auto-populate cells "N/A" when selecting from a drop-down list.

Thread Information

Users Browsing this Thread

Similar Threads

Is it possible to reverse the order in a cells "Drop Down List"?

[SOLVED] Auto-populate "Yes" "No" based on multiple criteria.

Cmd Button to populate all drop down list on a worksheet as "Yes"

Solution to populate cell with "X" by selecting "R"

Manipulate data presentation using "Drop down list" and "Filter"

Getting "like named" products to populate from drop down list

[SOLVED] "Create a drop-down list from a range of cells"

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions