Autofill cells that contain data validation

[nagovind]

Dear All,

Is there is any possibility to have auto-fill data entry if the cell contains data validation or by any means

The required LIST of data is in the range C1:C10

Individdual cells from A1 to A10 cell is with data validation with LIST referring to the req. data in the range C1:C10

If we start typing in the any of the cells under A1:A10 is there is any way around to auto-fill or predict option display among the data validation list linked to C1:C10

Please advise

Thank you
Govind

 

[lohithsriram]

Hi nagovind,

There is no direct way to do this. The below link has an idea. Check if this helps you.

http://www.contextures.com/xlDataVal10.html

 

[nagovind]

Hi lohithsriram,
Thank you for your reply
I have downloaded the file from the below link

http://www.contextures.com/xlDataVal11.html

Tried to include in my sheet but the same is not doing the job

Please help to resolve the issue. My file is "for autoFILL.xlsm" other is the downloaded file from the above linke

Regards

Govind

 

[Smallman]

Have a look at the attached file. I would steer well clear of merging all of those cells.

Take care

Smallman

 

[rsd007]

Hello,
As a rookie with excel, I will like to ask the Guru's and experts, Is there a way to Autofill cells with Data Validation without using VBA and or Custom Box ?
Thanks to everyone who will comment on this topic.