Data Validation
 

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

Data Validation
 

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 he

http://www.contextures.com

"SB" wrote:

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