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

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

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

You can only have one range filtered per worksheet--you can remove it and
reapply it elsewhere, though.

If you're using xl2003+, you may want to look at Data|List. It looks a lot like
autofilter.

wrote:

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



--

Dave Peterson

When I use autofilter and leave it on non blanks, it will not change as
I add data to the linked cell. Should teh filter change automatically?
What have I done wrong?

Dave Peterson wrote:
You can only have one range filtered per worksheet--you can remove it and
reapply it elsewhere, though.

If you're using xl2003+, you may want to look at Data|List. It looks a lot like
autofilter.

wrote:

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



--

Dave Peterson

The rows that are hidden/displayed won't change until you change the autofilter
criteria. It's not automatic.

wx4usa wrote:

When I use autofilter and leave it on non blanks, it will not change as
I add data to the linked cell. Should teh filter change automatically?
What have I done wrong?

Dave Peterson wrote:
You can only have one range filtered per worksheet--you can remove it and
reapply it elsewhere, though.

If you're using xl2003+, you may want to look at Data|List. It looks a lot like
autofilter.

wrote:

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



--

Dave Peterson

--

Dave Peterson