Data Validation

[SB]

I have an excel sheet having invoice information about our project. on
another sheet i have the clinet names and details . Is it possible to give a
validation sources from another sheet.

Also we have several project under one client is it possible to avoide
dulication.

Is it possible when i enter the project name excel automatically took client
details from another sheet

 

[Sean Timmons]

In order to use Data Validation across sheets, you must give a Name to the
desired list. Highlight the column you'll be using and enter a name in the
Name Box (Top left of your app, shows the current active cell).

Once you have the range named, you can go to Data > Validation, select List,
and type =YourName

To only have unique fields, I believe Debra Dagleish covers here:

http://www.contextures.com