Selecting data from a column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RON - 07 Mar 2007 00:52 GMT

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.

Signature

RON

Reply to this Message

Max - 07 Mar 2007 01:29 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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

Reply to this Message

RON - 07 Mar 2007 01:37 GMT

Thanks Max. Clear and to the point.

Signature

RON

> One way is to use a dynamic range within data validation
>
[quoted text clipped - 15 lines]
> > Essentially enter the name of the employee by choosing it from the column I
> > have allready imput.

Reply to this Message

Max - 07 Mar 2007 02:05 GMT

You're welcome, Ron.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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

Reply to this Message