Hi There,
I have attached my workbook. On sheet 2, of my workbook, there is a step 2 which is dependent on step 1. If you look at the values in the drop-down they are dependent on the drop down above. How do I make these values unique?
Please help.
Hi There,
I have attached my workbook. On sheet 2, of my workbook, there is a step 2 which is dependent on step 1. If you look at the values in the drop-down they are dependent on the drop down above. How do I make these values unique?
Please help.
Last edited by ertweety; 01-19-2012 at 10:52 AM.
Look here for dependent data validation: http://www.contextures.com/xldataval02.html
If you want to use VBA then have a look here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks