linking sheets

[Guest]

Hi All,

How do i link my drop down list in a13 sheet 1 to column f in sheet 2.

 

[JulieD]

Hi Jinx

if using Data Validation to create your drop down list the easiest way is to
range name column F in sheet 2
(go to sheet 2, click on F, click in name box (left hand side of formula
bar) type name (no spaces), press enter)

then click in Sheet1!A13, choose Data / Validation, choose List - click IN
the big white box, press you F3 key to bring up list of names in workbook,
choose the name, click OK, click OK again and it should work fine.

Hope this helps

Cheers
JulieD

 

[Frank Kabel]

Hi
have a look at
http://www.contextures.com/xlDataVal05.html
to use names for lists from other workbooks/worksheets

--
Regards
Frank Kabel
Frankfurt, Germany

Hi All,

How do i link my drop down list in a13 sheet 1 to column f in sheet

2.

 

[PegL]

Not sure what you mean by list box, so there are several
possibilities. If you mean a listbox or combo box from
the Forms Control menu, right click on it and select
Format Control. It will let you select both an input
range and a resulting cell. If it's a listbox from the
Control Toolbox, right click and choose properties. If
you mean a cell using data validation, name the cells in
column F as a Named Range, then set up the validation for
a List, then make the source "=yournamedrange" (without
the quotes and using the name you gave column F).