data Validation Dependent List Error

  • Thread starter Thread starter Marilyn
  • Start date Start date
M

Marilyn

I created a Data Validation Dependent List. In column A I have data
validation showing all of the departments in the company. Column B has data
validation with an Indirect function to show the positions based on the
department that the user selected in column A.

Things seemed to work fine, but now that i have the full list of departments
and positions I'm not able to view the positions for the department that is
being chosen from the drop down arrow. I can select a depart in column A but
I cant see any positions.

Please HELP!

thanks,
 
Could you please attach the sample file contain the database of Department,
Position and the relationship

Best reguard
Nattasira Yauvasuta
Thailand
 
To the original poster: Please don't attach files to your posts to the
newsgroups. These newsgroups are plain text (no attachments and no html).

To Nattasira Yauvasuta: If you want a copy of the the workbook, please ask to
have it sent directly to you.

(Or suggest that the file be uploaded to one of the file sharing web sites--like
www.savefile.com.)
 
Back
Top