How to create option or combo box within cell?

I don't see an attachment...

Thank you.

Like this?

Sorry did I miss anything here? I didn't see any changes, did you upload the right file?

click on cell E2 and your drop down will appear...

Actually it did not appear

Click on cell E2 on sheet Lead

On the Ribbon, go to Data and choose Data Validation, choose List

in the formula bar paste in

Please Login or Register  to view this content.

Press OK

Click on cell I2 on sheet Lead

follow the same instructions but paste in formula:

Please Login or Register  to view this content.

Thank you very much, this is exactly what I need.

No problem, please mark the thread as solved.

However, new issue comes up: e.g. after I have already created records for Client 1 - 9, I want the ability to allow user to create a new record based on the selection of the previous Client 1-9, I have no problem for creating new records for these clients since I created a list using your method, so I can simply select client1-9 from dropdown list. However, if I tried to create record for a new client say Client 10, it prevents me from doing that. Please see B11 to get an intuitive understanding.

Is there a work around for this?

Thank you again for your kind help.

Replace the formulas in the data validation as outlined below:

In E2:

Please Login or Register  to view this content.

In I2:

Please Login or Register  to view this content.

See if you can open this file...

I guess there is a misunderstanding here and I am sorry I didn't make it clearer. I have input some data in the spreadsheet, please see the attachment.

I have client 1-9 inputted in the sheet Lead with some info there.

I already created dropdownlist with previous populated Name Client1-Client9, if I want to add a new record for any of the client 1-9, I can choose from the dropdownlist; however, what about if I have 10th client to input? It doesn't allow me to manually type in Client10

I hope this is clearer now.

I don't think there's a misunderstanding, you should see all 10 in the drop down, as well as 11 and 12 and so on if you follow the instructions below:

Select the range where you want the drop down list to appear, for example E2:E20:

With that range highlighted, go to the Ribbon and choose > Data >>>Data Validation>>>List>>>

In the formula bar paste in:

Please Login or Register  to view this content.

Click OK

Now choose range I2:I20, make sure it is highlighted...

With that range highlighted, go to the Ribbon and choose > Data >>>Data Validation>>>List>>>

In the formula bar paste in:

Please Login or Register  to view this content.

Let me know if this is what you need...

Just a simple question for you: you have created B11 to take all client's names from B2-B10 (which are client1 to client 9), now come to a new client 10, how do you input "client 10" in B11? You need user to remove the formula in B11, that doesn't work for non-experience user, right?

Am I missing anything?

Thanks.

Hi,

There was no mention of Column B at all in your post. I didn't have any solution for column B...what is it that you want to appear in column B, just an automatic increment of client numbers? or do you want to be able to choose from a list??? for example, will it always be sequential, or can you have client 3 multiple times in the list?

Try this, look in column B

column B doesn't show anything, it's blank, see my screenshot.

Thank you