G
Guest
Hi All,
How do i link my drop down list in a13 sheet 1 to column f in sheet 2.
How do i link my drop down list in a13 sheet 1 to column f in sheet 2.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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
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
F
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
have a look at
http://www.contextures.com/xlDataVal05.html
to use names for lists from other workbooks/worksheets
--
Regards
Frank Kabel
Frankfurt, Germany
2.Hi All,
How do i link my drop down list in a13 sheet 1 to column f in sheet
P
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).
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).