populating neighbouring columns based on drop-down choice

M

mikeg

I have a worksheet which contains a column listing types of issues.
Another column lists examples of each of these issues. (e.g., "ALT
incorrect" is the issue and "ALT missing", "ALT should be empty", and
"ALT not accurate" are all examples)
The other worksheets all are testing results tracking these issues by
webpage. The issue column on each of these worksheets is populated as
a dropdown based on a Defined Name from the first worksheet's issues
column via a Validated Data List.
I would like to construct a neighbouring column on each of these
worksheets so that when I choose an issue from the first column, the
next column on that row is populated with the correct examples.
I know this must be dead easy, but can't figure out. Thanks for
assistance.
 

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

Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Combobox list based on choice in previous combobox 0
Combobox items based on choice in previous combobox 0
Auto-populate other cells based on dates 1
Auto-populate other cells based on dates 2
Need help with merging Excel worksheets and deleting unwanted columns 3
Requesting Help Please on Auto Worksheet Setup 5
Filtered drop down list 2

Top