View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SSDSCA SSDSCA is offline
external usenet poster
 
Posts: 9
Default Use Filtered Results for Data Validation

I have question on how to have the filtered results on one sheet be the list
for data validation one another sheet.

I have one worksheet that has a 10 column by 50 row filtered spreadsheet
that generally never has all 50 rows full of data that I need to filter by
serial number or date. That part works well, but I would like to use the
filtered results for data validation on another sheet. I sure the answer is
in the Discussion Group somewhere and I am not wording my "search for"
statement quite right.
--
Thanks and Regards,
Don