Data Validation List

[radhika0828]

i have created a data validation list on one worksheet named 'abc'.
now i want the same data validation list on several other worksheets in the same workbook through a kind of link so that if i make any changes to the data validation list on 'abc' the data validation lists on other worksheets automatically get updated.

[TMS]

You need to define a Named Range to refer to the list, for example, "nrABC", without quotes.

You can then use =nrABC in your Data Validation dialogue box.


Regards, TMS

[sktneer]

Hi Radhika,
Welcome to the forum.

What is your logic behind having multiple lists with the same content on multiple sheets in the same workbook? Why not just have one list and use it wherever it is required?

[TMS]

@sktneer: ah, I think I read that wrong. I thought he meant one list, referred to in DV on several other sheets. My bad, but you know where I'm coming from.

[radhika0828]

what i meant was that i want to create a source list on one sheet and apply data validation on a cell in that same worksheet to create a list.
now i want to link that cell to another worksheet so that the list appears in a cell in that worksheet.
i hope this is more clear.
although now that i think about it the 'naming the range' solution would also solve my purpose.

[sktneer]

No. Still unclear.
Are you talking about dynamic named range?
Dynamic Named Range is one which is updated automatically when you change the source list.

Its better that you upload a sample workbook describing your requirement in the workbook itself. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[sktneer]

Assuming your source list start from A1 on Sheet1, then you can make a dynamic named range using the following formula.....

Please Login or Register  to view this content.

Now you can use this named range in the data validation and if you update the source list, the changes in the source list will be reflected in the named range.