Thanks
can I have more than one autofilter on a sheet?

Sloth wrote:
Use the filter function
Select the data and click on...
Data-Filter-Autofilter
This should make an arrow appear at the top of the data (in the header row).
click the arror and select "Nonblanks".

" wrote:

Is there a way to automatically add/show rows that have data?
I have a data entry sheet. Then I have a report.
The report pulls data from the entry sheet.
If there is no data for a specific line/row item, is there a way to
automatically hide or not show the row(s) with no data?

Thanks