Excel Data Drop Down List from Another Sheet

This video explains how to create a drop down in Excel based on a list on another worksheet. It also explains how to get those drop down menus to automatically copy down into new records.

This tutorial will help you:
Create an Excel drop down list from another sheet
Create a drop down data validation list from another worksheet
Create a drop down that pulls data from another sheet
Populate a drop down from another sheet
------------------------

[TonTeezy]

Easy to follow and straight to the point. Thank you!!

[TheComish]

This helped me out soo much. I've come back to it once a year or so when I have to do it, and it's helped every time.

[lynnraypardo]

Thank you for showing how to create a table that includes the various validations. Unfortunately, when I attempt to place a list of values in another sheet, in Microsoft 365 for Mac, I receive an error message that doesn't allow the range :(

[mr.aliazmatshah]

Bundle of thanks. I learned something else from this video.

[jimmykomas]

You hit the nail on the head. Just what I wanted to do. Many thznks

[robertrumfelt]

Nice job, Chester! Thanks for putting this together!

[sunilbudke]

Thanks or this straight to the point video. You got a subscriber.

[jamesfinney]

Great video, you saved my butt on a budget sheet! For some reason the drop downs lists stopped populating when I got to row 220. Was able to fix it, thanks!

[mikedavis]

Thank you so much for doing this video is was so simple and slow enough to follow in one step I did a shopping list as I;m getting old I for get myself and buy what I don't need Again Big Thumbs up 👆 👆

[fifibee]

Thank you Mr Man you helped me so much

[jeremydaily]

from a distance I thought you were Jon Stewart from the Daily Show. Appreciate the short and sweet video

[skyfawn]

Hi, great Video. I noticed that your original lists had their cells coloured, is there anyway to copy that into the drop down lists? or copy other formatting.
I use a spreadsheet for diet planning with food items with their values on separate lists I have any cells in that list turn red with the text struck through after 12 months but I cannot get this to show on the drop down lists.
(Hope that's clear)

[juancarloscarrera]

Thank you. I have to look more than 10 videos to find this one. This is what I was looking for

[She_Tried_It]

OK, so if I'm doing web servers and I have a Server Profiles tab with 10 possible server profiles created, each row having about 10 columns of data per server. Is there a way to select the first server on the Server tab, select a server, and have say... 5 of 10 columns populate with default information? So I don't have to select the server and then select the additional 5 default items?

[vishweshwaruvish]

Can you explain how make similiar sheet with macro ?

[brandonchong]

Thanks A lot this is what i'm looking for. 👍👍👍

[johnkramer]

great video. However, i do not see the marching ants when i do INSERT --> Table option. I get the small pop up and upon clicking ok it highlights the header row with folters but the drop downs are not replicated for other rows. What am i doing wrong?

[sinabuseck]

I was wondering if there is a way to do this with a list created from another sheet?

[abhijittalathi]

SIMPLY CLICK ON SOUCE AND CLICK F3 TO GET LIST. YOUR CREATED LISTS ARE UNDER FORMULAS TAB UNDER NAME MANAGER