Drop Down Menu list for multiple sheets

**iamreese** · 03-02-2012, 10:27 AM

I have a drop down menu list using the data validation. My source is in sheet 1. I want to use the same source to sheet 2, 3, 4 and so on...how to do this?

**NBVC** · 03-02-2012, 10:30 AM

You would need to name the range so that data validation can use it as a source from other sheets.

To name the range, select it and enter a name in the Name Box just to the left of the Formula bar.

**iamreese** · 03-02-2012, 10:35 AM

Originally Posted by NBVC

You would need to name the range so that data validation can use it as a source from other sheets.

To name the range, select it and enter a name in the Name Box just to the left of the Formula bar.

Quite lost...I am in sheet 2, after I choose data validation and look for the source..what to do next? it does not allow me to go to sheet 1

**NBVC** · 03-02-2012, 10:50 AM

You need to go to sheet1. Select the range you want to make the "list" and then in the empty box to the left of the formula bar just type a name you want to give the list, e.g. MyList (alternatively go to Formula tab and select Define Name and enter the name there with the source being your list).

Then in Sheet2, in Data Validation, choose list and enter: =MyList