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

Move row based on value in cell 2
Delete rows based on contents of Col A 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Listbox populated based on Combobox 2
Adding columns based on new worksheets 1
Copy and paste to other worksheets 2
conditional formatting of cells based on result in hidden cell 1
Populating cells based on a combobox OnChange Event 1

Top