need help linking drop down list to second sheet
I assume that your drop down list is the one from menu Data-> Validation
->List. If that's the case then the souce field only accepts a reference
to a range, or a list or in if the range is on the other worksheets,
the name of the range, i.e You can't have =Sheet2!A2:A12, but =My_Data
with Sheet2!A2:A12 is name My_Data
Hope that will clear the air for you
Regards
Erymzuan Mustapa
Quote:
> I am working on a project and need some info. about how to make a drop down
> list but also how to link it to second sheet.
> Any help would be great..
