Create a drop down list with autofilter??

roughleg

Board Regular
Joined
Jun 21, 2004
Messages
181
I need a drop down list on one worksheet that reflects rows of data on a different worksheet that need data entry. Can autofilter be used in a formula to produce a list that can be entered as the source in data validation? The filter would be for blanks in column D and the list would be generated from results of the filter in column A. Any help would be greatly appreciated.
Skip
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,114,384
Messages
5,547,634
Members
410,804
Latest member
bluepinky
Top