use custom filter | choose is less than or equal to | put 0 and ok

you will get the names which are less than zero value and copy it &
paste it in sheet 2 col A.

Similarly for the value greater than zero.



On Nov 21, 1:53*pm, Junaid wrote:
I have one file with 12 months data, how i can bring my required month data
that when i select the month from the drop down list the selected month's
data could display and i could update the data but the details list should
not be display to the people. Thanks