Tables with dynamic validation lists

Hi all!

First off, congrats on the forums. I've come for several solutions, and answers & tips are usually there.

I come today with my first unresolved issue (which my gut tells me might be really easy, or absurdly complex). I am working in Excel 2010 (PC Version), and have a table with a data validation criteria (to create a list) that does not replicates itseft automatically when I add new rows to it. Weirdest thing is, another column of the table does have an equal data validation criteria which DOES replicate itself.

The validation criteria is as follows:

Please Login or Register  to view this content.

The table I'm having issues with is in the "Input" sheet of the attached file, specifically in column F. Column D has a similar validation formula, but does not present the problem (although I could not figure a way to eliminate duplicates from the dropdown lists).
If you need me to translate, I can do so. Also, if more details are needed, I'll be happy to provide them.

Thanks for any/all comments!

PS: The "Budget" sheet just shows #REFs, but it shouldn't be relevant I believe...

what is "the problem"??

I guess I'm confused - the validation is working (as in it IS there when I add a new row).

Add a new row - select the F column cell for that row, then look at Data>Validation (do you see a rule?).


I get the rule when I add a row - BUT the little pick-list you are expecting to see is dependent on the D column value (maybe you have left that cell blank in the new row?)