Ignoring blank Cells while Fetching Values

[Parthan]

Hi,

I have created a drop down cell based on the cells in the first row of a particular table. Now when i select a particular cell from the drop down i want to fetch all the values in the respective column of the selected cell on to a different group of cells. While fetching the data to those group of cells, i want to ignore all the null, blank cells. All this actions shall be automated and shall happen simultaneously on selecting the drop down. Please advise.

[redsab]

Parthan,
Do you have a worksheet you can attach or explain what cell the Data Validation (dropdown list) is in and where you would like the row copied to.
redsab