Based on two cells data validation list should be populated in third cell with unique vals

Hi,

In cell H5 there is list of dates and in H7 there is codex, based on these two conditions in H11 a data validation list should be populated from the code_sheet using column B. The populated list should be unique entries, as the column B in code_sheet has duplicates.

My apology, if posted this and seeking help in a wrong place.

Searched much, found something, but I was unable to make what i need from the searched codes / formulas.

Please do needful.
Also posted on.. http://www.ozgrid.com/forum/showthread.php?t=187749

Thanks & Regards
Chaitanya

Hi,

I used a Pivot Table to get a unique range of the code_sheet (B column)
The I created a dynamic range name of the data in the pivot to compensate for the shortening/lengthening of the list entries
Then I linked the validation rule to the Dynamic range name.

See sample file attached...

I have written a macro:
1. When you select a Date in H5: A unique list of CODEX will be shown in H7 (Criterion Date)
2. When you select a Codex in H7: A unique list of LOG IN will be shown in H11 (Criteria: Date & Codex)

The code can be written more compact because 3 subroutines are alomst the same. I think it works anyway.

UniqueDataInLists.xlsm

I forgotten to load list of unique dates. Occurs at Workbook_Open()

UniqueDataInLists.xlsm

Hi Joakim,

Its great working. thanks for the needful.
But, a small error which is occurring when i was trying to append data in the code_sheet to the existing data with the changes in dates column. It is not accepting if the dates were changed.
Also, there is a slight change in the requirement. Please find the attached format for to understand the change.
I know that the change in requirement will be irritating one, but, thought to ask.
Thanks & Regards
Chaitanya

Hi RudiS,

Your solution is so cool. But, if I paste manually one Codex on H7 in Code_Template, then the corresponding Log values only should be populate.
It is giving all the Log values in the column regardless of the Codex. Could you please look in.

thanks & regards
Chaitanya

Now the list of dates updates automical when you add dates in code_sheet.

I don't think I understand your desire above with "Range". I thought that all data should be shown in list just no duplicates. I am afraid you have to explain with an example or similar.

UniqueDataInLists.xlsm

The drop down values will now only show the categories based on H7...

Hi Joakim and RudiS,

Its been long time I didn't logged in. My apology for the delay in replying.
Both your solutions were working great! I modified accordingly to what I required/needed for the completion of my template using your codes or the techniques. Both codes/techniques helped me a lot to finish the task.

Thanks & Regards
Chaitanya

Excellent. Glad to hear the solutions are working well for you.