Dynamic Dropdown

[juriemagic]

Hi good people,

I am searching but not finding...please help me...In column A of sheet1, there are many duplicate company names. In sheet 2, A3, there is an INDIRECT/MATCH array pasted down to row 500, which references the names in sheet1, to give me a unique list. In sheet2, cell G4, I have a dropdown, which I want to be dynamic, which references the unique names. I have found numerous examples of dynamic dropdowns however they do not seem to expand as new names are entered in column A of sheet1.
So, a new name is entered into (NOT THE BOTTOM OF) the list, (second row from top of list), then sorted again, and the unique list in sheet2 updates. The dropdown however I need to also expand. Please help me..all and any help will be greatly appreciated..Thank you.

[Pepe Le Mokko]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[juriemagic]

Thanx for the assistance, I went to youtube and found my answer there. Thank you kindly...