Dynamic Data Validation

Is there a way to make the data validation dynamic. In other words, if I update the validation list can it auto update the cells that are tied to it? Right now if I update the list the original data does not change, which is causing havoc with the formulas I have tied to it.

Thanks in advance.

Thank you. Attached is my example. Test2 Beta Inventory System v2.1.xlsb

By way of an example, if I change cell A4 in the Client-Sales Validation List tab from "University of Florida" to "University of Southern Florida", the name stays "University of Florida" in cell B8 in the resulting "Sales Rep Forecast Input" tab. Ideally if I change the name of a record in the validation list I would like it to auto populate in the resulting cells.

Let me know if that makes sense.

Thank you trying. I will wait to see if someone has a trick up their sleeve.

Originally Posted by Perk1961

Thank you. Attached is my example. Attachment 426819

By way of an example, if I change cell A4 in the Client-Sales Validation List tab from "University of Florida" to "University of Southern Florida", the name stays "University of Florida" in cell B8 in the resulting "Sales Rep Forecast Input" tab. Ideally if I change the name of a record in the validation list I would like it to auto populate in the resulting cells.

1. Select A2:A105 in Client-Sales Validation List
2. go to INSEET tab, click Table
3. Go to DATA tab unclick Filter
4. Copy:

Please Login or Register  to view this content.

5. Go to Sales Rep Forecast Input
6. Select B8
7. Go to Data ==> Data Validation, change source with copied code, OK
8. Double click on the little square on the bottom right of selected cell.

to check:
change or add anything in your Client-Sales Validation List (A2:A105)
back to Sales Rep Forecast Input
check first or any other DropDown cell.

hope that is what you want.

sandy

Hi Sandy,

Thanks for your feedback. I followed all the steps you outlined but it did not change the results from my previous Data Validation List. I am wondering if there is a step I missed. Just to be clear, my goal is to be able to Change a name in the Client-Sales Validation List and have it automatically change the name in the cell that was referring to it without me having to reselect it from the drop down list.

Attached is an updated file with the changes I made per your recommendation. As you will see, I changed the name in cell A4 of the Client-Sales Validation List to "University of Southern Florida2" but it did not automatically update the contents in cell B8 of the Sales Rep Forecast Input tab. Of course I am able to select the updated name from the drop down list, just as I was able to do before this change, but I am trying to avoid that step as it is too laborious. Moreover, my task will involve copying and pasting a variety of new names into the other Validation lists like this, which need to update those cell results so I do not have to go back in and manually reselect each one.

I hope that makes further sense.

Thank you in advance.

I misunderstood before, sorry
Like above ppl said: it is impossible without VBA.

Thank you. Would you know how to create a VBA that solves this?

Thank you. Do you know how to create a VBA to do this task?

Got it. Thank you.