Selecting data from a column

R

RON

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.
 
M

Max

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
 
R

RON

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


Max said:
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
Click to expand...
 
Top