Autofill of cell data based on each other and allow dropdowns.

Have been working on this sheet longer than I wish to admit, so I finally am going to see if there are options other than what I have attempted.

The end result of the sheet is to be a ledger of sorts.

4 columns present with the headers
Name | Account Number | Amount | Designation

The Name and Account numbers I need to populate each other, as well as allow for free entry into the cell. I.E. If a name is entered into the first slot, and it has an associated account number, populate the number. If a number is entered, but no name has been entered yet, enter the name.

Boxes need to be sorted by numeric or alphabetical.

The name and Account number need to be free entry boxes as well, so new information can be added to them. If a name is entered into the box that has not before, it needs to be added to the drop down menu for the boxes.

I have been able to get a single box working, and the numbers to add using Vlookup() or a Vlookup(Match()) combination, but when attempting to get the cells to populate each other, I run into issues.

I also run into issues when attempting to sort the lists by numeric or alphabetic. When the drop down is clicked, I attempt to have the affected list sort itself (If the name is dropped down, I have the list sort by alpha; if the account number is dropped down, I sort the account numbers) but I have to sort both lists and keep the associated name/account numbers together.

I have been attempting to get these to work correctly for quite a while. I am doing this as a courtesy to a friend, and attempting to get as many items as I can to work.

All help is greatly appreciated! Thank you.

It would help a lot if you could provide a sample workbook with sample data. It will make it easier to visualize the issue and make it easier to provide the solution.

From the description, I think you could do the following: you can make a pivot table off the list to get the current list of unique names. Then "overlay" a named dynamic range over this. Use the named range as a source for your dropdown lists.