Add rows automatically? Accordion

W

wx4usa

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
 
D

Dave Peterson

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.
 
W

wx4usa

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?
 
D

Dave Peterson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically add/hide rows 13
hiding rows 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Help to copy information from one row at a time to another sheet 1
how to automatically populate a cell? 1
auto number 4
Access Page Header with merge field 0
copy data from master sheet 6

Top