Data Validation Lists Across Multiple Sheets

**mosswood17** · 05-29-2013, 06:49 PM

I was wondering if there was a way to utilize a list for data validation purposes across multiple sheets. I have a list of people on Sheet 1 in a table but would like that list to appear in drop-down fashion in a table on Sheet 2. Is there a way to do this? Thanks for the help!

Nick

**FDibbins** · 05-29-2013, 06:51 PM

Give the list a named range, and then reference the name in the DD =the_name_you_gave_the_range

**mosswood17** · 05-29-2013, 07:06 PM

Originally Posted by FDibbins

Give the list a named range, and then reference the name in the DD =the_name_you_gave_the_range

Thank you very much for your extremely FAST response! I am having a bit of trouble understanding where the Range name is used. How do I incorporate the range name into data validation to allow for those items to appear on a drop down menu?

Thanks again.

**FDibbins** · 05-29-2013, 07:13 PM

DV wont accept a range from another sheet, so to get around that, you give the list you want to use for the DV (on sheet1?). You can then use that named range as a reference for the DV on sheet2

highlight the range on sheet1
right-click/name a range - give it a name (lets say This_Range)
top to sheet2, select the cell where you want the DV
select DV, select LIST, in SOURCE, type =This_range (caps dont matter, spelling does, and you cannot use spaces)