Automatically fill cells when selecting from a drop down list

L

Liotta

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
 
L

Liotta

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatted cell column in drop down list 1
Drop down tabs that can auto fill certain information? 3
drop-down list 2
Excel drop down menus 1
Auto fill Cells with text 2
Drop Down list that fills in other cells 1
customize drop-down box 1
Drop down list selections creating values in adjoining cell 1

Top