Insert Validation List from another Sheet (Excel 2003)

**Excelnoub** · 09-18-2012, 02:04 PM

Just wondering if this is possible and if so if someone would be kind to let me know how.

I have 5 Sheets and one stand alone sheet therefore 6 sheet total. My 6th one is for information only.

My first 3 sheets have validations in them that are the same information. I do not want to create a form as I have a lot of VB coding also.

Is there a way that I could use my last sheet (that will be afterward hidden) as a reference?

I mean I would love to spend my time updating every sheet... but in reality to quicker the better.

Let’s say on Sheet6 from A1 to A20 I will have a validation list. Then in my Sheet1 G5to G30 I would make reference to my Sheet6.

**tigeravatar** · 09-18-2012, 02:18 PM

Excelnoub,

Yeah, you just need to use a named range. So say your list of items is in Sheet6 A1 to A20 like you've stated. Select those cells and then name that range as list_Description (that's just my naming convention. So if it is a list of names, it would be list_Names. if it is a list of parts it would be list_Parts, etc. You can use whatever name you want though).

Then in Sheet1 G5, set the data validation list formula as =list_Description and click OK. Now the validation list will be those items on sheet6. Then just copy that cell and paste wherever else you'd like the same data validation list to be.

**Excelnoub** · 09-18-2012, 02:27 PM

tigeravatar...You are awsome Thank you.

**tigeravatar** · 09-18-2012, 02:36 PM

You're very welcome

If that takes care of your need, please mark this thread as solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save