C
Chris Hankin
Hello, could someone please advise on how I can make a selection from a
drop-down box that is linked to a Data Validation List in the following
way?
Worksheets named:
Form &
Local and Global Profiles
Defined Name: Local_Profile_Name = 'Local and Global
Profiles'!$A$2:$A$66
The Worksheet named: Local and Global Profiles contains 3 columns.
Column A: Local Profile Name (A1:A66) A1 cell has the text: Local
Profile Name as a header. Column B: Corresponding Global Name (B1:B66)
B1 cell has the text: Corresonding Global Name as a header. Column C:
Incumbent (C1:C66) C1 cell has the text: Incumbent as a header. Thus,
each Local Profile Name has an associated Global Profile Name and an
Incumbent.
In the Worksheet named: Form, I have used a Data Validation List for
cells: (C10:C19). The Data Validation List = Local_Profile_Name
What I am trying to accomplish is that when I use a drop-down box on the
Worksheet named: Form in cells (C10:C19), I would like the associated
data (found in the Worksheet named: Local and Global Profiles) for my
selection to automatically populate the adjacent cells in the range
D10:E19). So, when I make a selection in cell C10, then cells D10 and
E10 are automatically populated with the associated data for that
selection.
Please follow this example to clarify:
If I use the drop-down box on the Worksheet named: Form in cell C10 and
choose 'shop assistant' (without the quotation marks)as the Local
Profile Name, I need the associated data of the Corresponding Global
Name (located in Worksheet named: Local and Global Profiles) of 'shop
supernumery' (without the quotation marks) to be automatically populated
in the worksheet named:Form in cell D10.
Also I need the associated data of the Incumbent (located in Worksheet
named: Local and Global Profiles) of 'Attendent' (without the quotation
marks) to be automatically populated in the worksheet named: Form in
cell E10.
If anyone could please help that would be greatly appreciated.
If you need further clarification, please let me know.
Kind regards,
Chris.
drop-down box that is linked to a Data Validation List in the following
way?
Worksheets named:
Form &
Local and Global Profiles
Defined Name: Local_Profile_Name = 'Local and Global
Profiles'!$A$2:$A$66
The Worksheet named: Local and Global Profiles contains 3 columns.
Column A: Local Profile Name (A1:A66) A1 cell has the text: Local
Profile Name as a header. Column B: Corresponding Global Name (B1:B66)
B1 cell has the text: Corresonding Global Name as a header. Column C:
Incumbent (C1:C66) C1 cell has the text: Incumbent as a header. Thus,
each Local Profile Name has an associated Global Profile Name and an
Incumbent.
In the Worksheet named: Form, I have used a Data Validation List for
cells: (C10:C19). The Data Validation List = Local_Profile_Name
What I am trying to accomplish is that when I use a drop-down box on the
Worksheet named: Form in cells (C10:C19), I would like the associated
data (found in the Worksheet named: Local and Global Profiles) for my
selection to automatically populate the adjacent cells in the range
D10:E19). So, when I make a selection in cell C10, then cells D10 and
E10 are automatically populated with the associated data for that
selection.
Please follow this example to clarify:
If I use the drop-down box on the Worksheet named: Form in cell C10 and
choose 'shop assistant' (without the quotation marks)as the Local
Profile Name, I need the associated data of the Corresponding Global
Name (located in Worksheet named: Local and Global Profiles) of 'shop
supernumery' (without the quotation marks) to be automatically populated
in the worksheet named:Form in cell D10.
Also I need the associated data of the Incumbent (located in Worksheet
named: Local and Global Profiles) of 'Attendent' (without the quotation
marks) to be automatically populated in the worksheet named: Form in
cell E10.
If anyone could please help that would be greatly appreciated.
If you need further clarification, please let me know.
Kind regards,
Chris.