• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamically generating names while typing

A

Amit Jain

New Member
can you help me to create such kind of sheet, like while entering names, excel will automatically generate names from previous names.
for example i have Amit, Rajendra, Deepak, Prem, Nisha, Deep, Aman, Ajit as names .. while typing new name in field, as soon as I type "A" excel shows "Ajit" , "Aman" and then "Amit" if possible "Rajendra, Deepak and Nisha" too, and then after typing "AM" only shows Amit & Aman !! like it shows in Tally & other softwares !!
plzz help
 
I believe XL already does this...it just needs to be in the same column. If you Type "Amit" into A2, and then start typing "am" into A3, XL will suggest a completion for you. Is this different than what you are looking for?
 
Hi Amit ,

Please check that under Excel Options -> Advanced , you have the following checkbox checked :

Enable AutoComplete for Cell Values

If this is not checked , Excel will not suggest any text automatically.

Narayan
 
No sir !!
I'm not asking about autocomplete.
Suppose I have Amit in cell C2 and Aman in C3, then while typing in cell C4 as soon as I type A, it shows a list with Aman and Amit to select from a drop down list.
 
If I type "A" in cell C15 in the attached file, it should show all names containing "A" in sorted order, the after typing "AM", should show "Aman" & "Amit" and give an option to select from the either !!
hope i'm clear now
 
dear amit,
go through the attach file, there are some marked cells with yellow colour, double click on any cell and start writing. is this solve your problem let us know that and then we can explain you.
 

Attachments

  • data validation with search module.xlsm
    23.8 KB · Views: 9
No Sudipto Sir ...
I wasn't looking for that ... thanks for helping, I want dynamic results while typing data !! and more importantly on the same column ... like it happens in Tally !!! plzz help and try again bhai ... :)
 
You could do this with an ActiveX dropdown box, but the cells within XL do not support this feature. You can do the auto-complete, or you can press Alt+down arrow to pull up a list of previous entries.
 
Amit

You will find an excellent article on Autocomplete here on Contextures.

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

It is not quite what you are after but I think the end result is exactly what you are trying to achieve. It is a double click procedure. Double click on any of the cells in Blue and start typing.

Take care

Smallman
 

Attachments

  • 1Exp.xlsm
    22.2 KB · Views: 9
No Samallman Sir...
Sorry, I haven't got my solution yet ...
I want to dynamically get results while typing ... plz see my question once again !!!
Anyways thanks for giving time for my query, will be great if you give another thought ...
Thank U
Amit Jain
 
Sorry Amit

What I have provided is as good as I have on this problem. You are going to struggle in my opinon, but have been known to be very wrong.

Smallman
 
Last edited:
Smallman and SirJB7 are correct. Excel can not do exactly what you are asking for with just a cells. Mimicking the behaviour using Debra's double-click procedure is the closest thing I have see. it's possible to change the procedure from double-click to just select...but I would strongly advise against that, as it would get very messy.
 
Hi Amit!

Please see attached file. I think it will be work!

Regards


Zameer
 

Attachments

  • Item Search by COMBOBOX.xlsm
    22.9 KB · Views: 14
Thanks everyone for your help & suggestions !!! spcly Smallman & SirJB7 !!
don't think will get the exact solution I wanted ...
 
JAMIR said:
Hi Amit!

Please see
Click to expand...

Hi

It`s almost what I am looking for, exept that combobox seems to be moving around? If you could make this namelist with different names in b1:b20, and combobox in b24, then I think Amit would use it.
I wouldo_O
(If you could add a function in this sheet so it was poosible to type in the combo?)
 

Attachments

  • Expanded dropdown_example.xlsx
    45.5 KB · Views: 12
Last edited:
You must log in or register to reply here.
Back
Top