Previous Topic Next Topic

Creating a dynamic list

Closed
Prathibha - Jun 9, 2010 at 06:45 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 9, 2010 at 07:14 AM
Hello,

I have two sheets. I have a table in the second sheet with customer name. I need to create customer list and pop down the list in first sheet. How to do this? Note the customer name may add or deleted in run time. How to handle this dynamic list.


1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 9, 2010 at 07:14 AM
You can have the customer names in a sheet and have data validation on based on that range.