Selecting data from a column
 

I want to select from a column that contains a list of titles that I have
imput.
I want the selection to be placed in a differing column such as employee name.
Essentially enter the name of the employee by choosing it from the column I
have allready imput.
--
RON

Selecting data from a column
 

One way is to use a dynamic range within data validation

Suppose the titles are in Sheet1, running in col A,
with header in A1, data in A2 down

Click Insert Name Define, and define a range:
Names in workbook: MyList
Refers to:
=OFFSET(Sheet1!$A$2,,,COUNTA(Sheet1!$A:$A)-1)

Then in any sheet in the book,
you could just select the desired col,
then click Data Validation, Allow: List, Source: =MyList, OK
The droplist of titles will be made available for selection in that col
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RON" wrote:
I want to select from a column that contains a list of titles that I have
imput.
I want the selection to be placed in a differing column such as employee name.
Essentially enter the name of the employee by choosing it from the column I
have allready imput.
--
RON

Selecting data from a column
 

Thanks Max. Clear and to the point.
--
RON


"Max" wrote:

One way is to use a dynamic range within data validation

Suppose the titles are in Sheet1, running in col A,
with header in A1, data in A2 down

Click Insert Name Define, and define a range:
Names in workbook: MyList
Refers to:
=OFFSET(Sheet1!$A$2,,,COUNTA(Sheet1!$A:$A)-1)

Then in any sheet in the book,
you could just select the desired col,
then click Data Validation, Allow: List, Source: =MyList, OK
The droplist of titles will be made available for selection in that col
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RON" wrote:
I want to select from a column that contains a list of titles that I have
imput.
I want the selection to be placed in a differing column such as employee name.
Essentially enter the name of the employee by choosing it from the column I
have allready imput.
--
RON

Selecting data from a column
 

You're welcome, Ron.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
On Mar 7, 9:37 am, RON wrote:
Thanks Max. Clear and to the point.
--
RON