Hi

I have a data validation dropdown list. When I select an item, some
records are to be populated in the rows below with the use of HLOOKUP
function. The HLOOKUP functions brings the values from other sheet and
populate them over this sheet. It will have one to one thousand rows
depending upon the Item selected. So, if there is just one record for
an item then the other rows will show zeros.

I need to hide those rows which shows zero values, when the list is
clicked. It could be done through Autofilter, but I need the VBA code
for this. Also the Autofiler button shouldn't be viewed (but that is
not an issue)


Please help.

Shail