Dear Sir,
I want to make filter list of one column as a dropdown validation list of another cell,
Please help

Ex : The filter list of column A ( A1 as heading) will be used as validation list of cell B1

Please help