populating DropDown with Values Of a Column in another Sheet.

[ZarrinPour]

Hi
I have two Sheets ,in first one i have two columns (Code & Name) and in
second one i have created an invoice Note that the first sheet may be
updated.now in second sheet i want to populate a cell (Data Validation)
with all values of the "Code" column in the fist sheet .how can i do
that.?

Thanks in advance.
Regards.

 

[Bob Phillips]

Create a name (Insert>Name>Define...) for the Code column of say a name of
CodeRange and a Refersto value of

=OFFSET(Sheet1!$A$1,,,COUNTA(Sheet1!$A;$A),1)

and in the DV use a type of List and set to =CodeRange

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[JudithJubilee]

Hello ZarrinPour,

Highlight all the code cells on your first sheet and press Ctrl + F3. Name
the range, eg. CodeList (you are not allowed spaces)

Go to the second sheet and highlight all the cells to which you want to add
the drop down. Choose Data + Validation + Settings tab. Vhoose List from the
dropdown and type =CodeList at the bottom.

Judith

 

[JudithJubilee]

Bill's is better!!
--
Hope this helps

Create a name (Insert>Name>Define...) for the Code column of say a name of
CodeRange and a Refersto value of

=OFFSET(Sheet1!$A$1,,,COUNTA(Sheet1!$A;$A),1)

and in the DV use a type of List and set to =CodeRange

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Bob Phillips]

Who's Bill?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Debra Dalgleish]

Bill Phobips?

Who's Bill?

 

[Bob Phillips]

Oh, him! I think I know him.

Bill Phobips?

 

[JudithJubilee]

Araghhh!!!!
A fantastic example of trying to show respect but it bitting you on the *!!

Sorry Bill!

I see you all the time but the only time I don't scan my post before
sending....

:')

Judith