Restricting drop down box values to filtered

Closed

Seahawks - Aug 22, 2010 at 05:51 PM
rizvisa1

Posts: 4479
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: May 5, 2022

- Aug 24, 2010 at 08:25 AM

Hello,
How do I format a drop down list box that captures only filtered values and changes the values depending the filters? I have a spreadsheet that has about 8,000 rows and about 20 columns. I have filters on each of the columns and would like to create a list box that displays only the filtered values. Can this be done?

Restricting drop down box values to filtered
Drag and drop virtual box - Guide
Changing values in one cell depending on drop down list values in another cell ✓ - Forum - Excel
Pasting values in filtered cells ✓ - Forum - Excel
It restricts what values are possible for cells that contain numbers, dates, and text ✓ - Forum - Excel
What is drop box - Guide

1 reply

Answer 1 / 1

rizvisa1

Posts: 4479
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: May 5, 2022

769
Aug 24, 2010 at 08:25 AM

See if this helps
https://ccm.net/forum/affich-269392-dropdown-lists-in-excel-2007

Subscribe To Our Newsletter!