If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|