display unique list in dropdown in each subsequent cell

Hi,

I am looking to get a list of unique data without any duplicates to be displayed in dropdown in G column and in gets update with new data in subsequent cells as well in previous cells.But the data so displayed in G column should be unique to F column.For eg.

if I type in F12 = Ram Kapoor,then it will search all the Ram Kapoor corresponding list of data in G column and display in dropdown without any duplicates in G12.
But if in F12,if the data is new type and does not exist then it will allow one to do entry in G column that will be updated in next cells and previous G column cells.

Hope I could be able to make it understand.

Code is included from http://www.excelforum.com/showthread.php?t=1148579

Hope modification in it will ease.

With helper sheet called unique, you can hide
With dynamic named range on this sheet

and this code

Please Login or Register  to view this content.

Kind regards
Leo

Maybe

Please Login or Register  to view this content.

Kind regards
Leo

also little cange on dynamic named range

Hi paradise2sr,

Try the following code included in the attached modified copy of your file. This works on Sheet1 only.

In the Sheet 1 Code module:

Please Login or Register  to view this content.

In ordinary code module ModDataValidation:

Please Login or Register  to view this content.

Lewis

Hi,

I implemented all your requests. There are now 3 main routines to do the processing:
a. CreateDataValidationForOneNameController() - This process a one cell change in Column 'F'. It actually has to do two passes. The first pass puts the 'Data Validation' in Column 'G' for the 'New Name' in the Cell in Column 'F'. The second pass puts 'Data Validation in Column 'G' for the name in Column 'F' that was just deleted (it it still exists in other cells in Column 'F').
b. NewNameInColumnGDataEntry() - This puts the 'Data Validation' in Column 'G' for the 'Name' in the Cell in Column 'F'.
c. CreateTheEntireDataValidationList() - This is similar to the routine in the previous version, and calculates 'Data Validation' for every non-blank cell in Column F. This still takes a long time. It is only activated when more than one cell changes value (e.g. when a cut and paste is done).

In the Sheet Code module (for each sheet you want to run the software):

Please Login or Register  to view this content.

Lewis

Code is too long for one post - will be continued in next post.

Code from previous post - continued

In ordinary code module ModDataValidation:

Please Login or Register  to view this content.

Code from previous post - continued

In ordinary code module ModDataValidation:

Please Login or Register  to view this content.

That's awesome and fantastic !

For a long time I was looking for this type of issue and ultimately you have solved it.

Thanx a lot and I am really grateful to you for the pain you have taken to resolve my issue.