Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically fill cells when selecting from a drop down list
Hi - I want adjacent cells to automatically fill in when I select an item
from a drop down list. For example, my list contains Manager, Supervisor; GA and if I click 'Manager' I want certain corresponding cells to autofil and if I click 'GA' I want other cells to fill. Can anyone help??? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically fill cells when selecting from a drop down list
Hi,
Please refer to Excel's VLOOKUP() function. Please type VLOOKUP() function in Excel's Help menu. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Liotta" wrote in message ... Hi - I want adjacent cells to automatically fill in when I select an item from a drop down list. For example, my list contains Manager, Supervisor; GA and if I click 'Manager' I want certain corresponding cells to autofil and if I click 'GA' I want other cells to fill. Can anyone help??? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically fill cells when selecting from a drop down list
Hi Ashish - thanks for your prompt reply - can I just check something? For
example if have a list of training courses going across the colums and I've created a drop down list of job roles. What I want to happen is, if I click Manager then a 'YES' is automatically entered into the cells under all the training courses that a manager should do? Is it still VLOOKUP I should be trying to master? Thanks again! "Ashish Mathur" wrote: Hi, Please refer to Excel's VLOOKUP() function. Please type VLOOKUP() function in Excel's Help menu. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Liotta" wrote in message ... Hi - I want adjacent cells to automatically fill in when I select an item from a drop down list. For example, my list contains Manager, Supervisor; GA and if I click 'Manager' I want certain corresponding cells to autofil and if I click 'GA' I want other cells to fill. Can anyone help??? Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically fill cells when selecting from a drop down list
Hi,
Looks like. IF you face a problem, please mail the specific question. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Liotta" wrote in message ... Hi Ashish - thanks for your prompt reply - can I just check something? For example if have a list of training courses going across the colums and I've created a drop down list of job roles. What I want to happen is, if I click Manager then a 'YES' is automatically entered into the cells under all the training courses that a manager should do? Is it still VLOOKUP I should be trying to master? Thanks again! "Ashish Mathur" wrote: Hi, Please refer to Excel's VLOOKUP() function. Please type VLOOKUP() function in Excel's Help menu. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Liotta" wrote in message ... Hi - I want adjacent cells to automatically fill in when I select an item from a drop down list. For example, my list contains Manager, Supervisor; GA and if I click 'Manager' I want certain corresponding cells to autofil and if I click 'GA' I want other cells to fill. Can anyone help??? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically selecting items in drop down list | Excel Discussion (Misc queries) | |||
Need a drop down list to auto fill other cells... | Excel Discussion (Misc queries) | |||
Clearing cells when selecting from a drop down list | Excel Worksheet Functions | |||
Help! I want to fill cells as a result of selecting a value from a list in another cell. | Excel Worksheet Functions | |||
Auto Fill Cells, When Choosing From Drop-Down List... | Excel Worksheet Functions |