Excel 2003

[Amjad Dari]

hi :

i want to know how to create a drop down list where the
list exists in different sheet. i followed the help but
the Validation command is giving error that the list
should be in the same worksheet.

regards.
please copy the reply to my email address

[sathyam1968]

The procedure is simple. Follow the steps one after the other in sequence.

1) Define the original list in other sheet
2) Define a name for the list of values. That is select the values and
Insert -> Name -> Define
3) Go to the sheet in which the list needs to be used
4) Select a set of cells in which the list in the other sheet needs to be
used.
5) Choose Data -> Validation and under Allow: option choose List
6) In the source give the name that you have defined. The name should be
preceded by the = symbol.

Now the list will work perfectly from other sheet into the current sheet.

Sathyamurthy.B
*************************

Post by Amjad Dari
i want to know how to create a drop down list where the
list exists in different sheet. i followed the help but
the Validation command is giving error that the list
should be in the same worksheet.
regards.
please copy the reply to my email address