Good Day;
how to remove the blank list in drop list?
https://www.dropbox.com/s/k6m1x2azok...mple.xlsx?dl=0
thanks a lot
Good Day;
how to remove the blank list in drop list?
https://www.dropbox.com/s/k6m1x2azok...mple.xlsx?dl=0
thanks a lot
1. Created a new Sheet3
2. In cells A1:A4 entered list of four schools
3. In Name Manager, defined list with Name "List"
4. In Data Validation, changed look up to the defined "List"
See attached.
Alan
Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
Like my answer? Click * below
Database Normalization
Database Principles
Pivot Table Tips
Excel Video Tutorials
SumProduct Video Tutorial
DataPig Access Tutorials
MS Query Tutorial
SQL Tutorial
I not good in excel, please give me the sample formula?
https://www.dropbox.com/s/hy8jqbbe0x...heet.xlsx?dl=0
crossposted: droplist
Alan
Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
Like my answer? Click * below
Database Normalization
Database Principles
Pivot Table Tips
Excel Video Tutorials
SumProduct Video Tutorial
DataPig Access Tutorials
MS Query Tutorial
SQL Tutorial
Bookmarks