How To Auto Populate Text From A Drop-Down List Selection in MS Excel - Create Fillable Forms

Fantastic video, very easy to follow. Thanks!

This was such a good video, it was exactly what I was looking for. Thank you!!

When I attempt to make drop down I get a promt the list source must be delimited list or a reference to single row or column. Not allowing me

This is fantastic. Thanks. I have a started a quote sheet by following this process. Now I have a cell that needs to say If this, then 0 and if that, then doe a vlookup. When I try this, I get a correcting saying I am putting too much in the cel.

Thank you for this very informative video. 😇❤️

Perfectly explained, thank you so much!!

I need a different type of fillable sheet can you help?

Thank you so much for making this look so easy! 😃

I need to use two drop down lists to auto populate a third cell?

Excellent presentation. Thank you!

Not working i tried couple of times

Excellent video. Clear, and very well presented. There are others I've watched on the same subject where the channel creators hum and ha, are constantly clicking for no apparent reason and I'm left feeling irritated and confused. Not so with this demonstration. So, many thanks for the video. It's much appreciated. 👍👍

Its so easy to understand, thaks.
How put formula to auto fill wholesale, retail and mrp in different Calum after select a product from dropdown.
Please help

Great help thanks was trying this from other places byt yess i did it. Thanks to you

Hi, data validation not working 2007 it does not pick source col from other sheet

How can I include a "Select all" option in a drop down list?, because once an option is selected I can't look all the options again.

saved my life.
easy to follow along. Thanks for a very useful content for a beginner like me!

Your videos are so helpful. Thank you! Do you have another video on how to print multiple selections from these dropdown list forms?

Great for Excel but can it be done in Word?

I have my first dropdown with 2 selections: Standard Glass and Tempered glass. I have another dropdown where the user can select the width of the glass.

My problem: the second dropdown values need to change depending on what kind of glass was selected in the first dropdown.

Please provide the solution

i am trying to have the choices in the dropdown list to populate another sheet or orderform

The most detailed video ever. Thank you a million for this.

it was so helpful, thank you, I used in a tab I named payroll getting the data from another tab tha I named data it worked perfect!, now I'm stock trhying to get the total hrs from another tab I named week containing all people in the company some worked some didn't, is there a formula that let me get the total hrs only from people who worked? Thank you in advance for your reply Sharon kind regards

Can this also be done on MS Word? I would like to automatically populate a field on word based on a previous dropdown.

Perfect, thank you so much, I've managed to do what I needed from just one video, amazing!

Your amazing Sharon!

This is genius. I have been looking for this. Thank you so much for explaining it to the point !!!

I looked at about 7 different videos on this topic and none made sense. This one was perfect and easy to follow. The main different, the rest were all taught by men. LOL! Lesson learned. Thank you!!

When I set up Data Validation the drop down still has blanks even tho 'Ignore Blank' has been checked. Why does it work for you but not me?

👍🏽👍🏽👍🏽😊

What if it's not working for some of the cells?

This is exactly what I needed, thank you!

perfect explanation

Thankyouuuuuuuu!!!!!!❤

Is there any possible way in excel to have automatic completion work for all columns, in fact for the entire worksheet?

Why doesn't this want to work for me. I got it down to a T but the lookup comes back with an error :(

Thanks!

Sharon, thank you for the video. I can't seem to get my drop down list to update once I've added rows to my selection data.

Hi sharon,thank you so much for the video ,I'm currently analyzing extensive data from Zip codes in many states, such as income, population, and housing units. I'd like to compare the primary zip code to the zip codes of the nearby neighborhoods.

For example, 30311 need be split into other cells in the same row along with neighbors zip codes (30310,30314,30318,30331)
Per Zip 30311 30310 30314 30318 30331

The idea is that when I write one of these codes, the neighborhood zip codes are automatically split in another cell, along with the data that I will fill later.I would be grateful if able to share any idea on how to do that
once again thank you so much for your helpful videos 🙏

Hello! Thank you for your videos. Is the same thing possible in Word?

Thank you so much.

Ive made a macro to copy the customer details on an invoice form to a customer list (New_Customer) however the efficiency of this is only usefull if we can populate the main cell still from a list. I'd love it if you have a work around for getting autocomplete (Normally on same column data) on the customer name cell, to come from the customer list, but still allow the new entry so new customers can be added still with the macro. All I can think of is hiding another copy of the customer name list in the colum below the invoice form so autocomplete works

Excellent video!

Awesome vid simple and to the point!!! ;))

This is exactly what I was looking for! Thank you!

Not really helpful, I wanted to know how I can make it so that a dropdown list has by default a name inside it when I insert a new row.

Thank you very much

Is there a drawback to turning a datasheet/database into a table since I would line to get be able to pull customers by their phone numbers as I create new invoices? Is there a limit to a table versus a nun table database? Hope make question makes sense..

Thanks for the info 👍

Exactly what I was looking for today! Thank you so much!