Show data which rows are not hidden

Hi,

I have a combo box named 'Drop Down 14', I need this combo box should list the data which rows are not hidden.

For e.g.:- I have data in row 2 & 3 (Column L) and row 2 is hidden & row 3 is not hidden, I want the combo box should list only row3 data.

The data are in sheet1.

Please help.

Thanks.