Forum Discussion

u234l530's avatar
u234l530
Copper Contributor
Oct 27, 2023
Solved

Dropdown List to return a unique value

Please help me with my workbook as Iam novice to Excel. I have 2 sheets, "STOCKS" and "ORDERLIST" .....I want to automate in Allocation Column the email address of the client matching the criteria o...
excel
Formulas and Functions
Macros and VBA
office 365
Office Scripts
  • rachel's avatar
    rachel
    Oct 29, 2023

    u234l530 

     

    Hi,

     

    I use TRANSPOSE + FILTER function to filter out client emails.

    Then I put =$K2# in the data validation list for the drop down. so now you can choose which email to send.

     

    (I attached the excel INV Mngmt_dropdownlist.xlsx here).

     

     

     

rachel's avatar
rachel
Iron Contributor
Oct 30, 2023

u234l530 

 

I just tried to delete a row in Client's Order List. The dropdown list refreshed.
I am using Office365 Desktop.

 

Maybe you can try to set your "Calculation Options" to "Automatic".

 

 

 

 

u234l530's avatar
u234l530
Copper Contributor
Oct 30, 2023
Hi Rachel, Works now Awesome...Thank you once again....have a great day ahead!

Resources