ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I insert combo drop box and still be able to sort? (https://www.excelbanter.com/excel-worksheet-functions/39564-how-do-i-insert-combo-drop-box-still-able-sort.html)

Anne Jett

How do I insert combo drop box and still be able to sort?
 
I am working on a rather large database that is used by several people within
the company...we have many product models to choose from, so I have inserted
the combo drop boxes but now I can no longer use the sort function. Any
ideas????

Debra Dalgleish

Instead of combo boxes, you could use data validation, which would sort
with the data. There are instructions in Excel's Help, and he

http://www.contextures.com/xlDataVal01.html

Anne Jett wrote:
I am working on a rather large database that is used by several people within
the company...we have many product models to choose from, so I have inserted
the combo drop boxes but now I can no longer use the sort function. Any
ideas????



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 11:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com