Add rows automatically? Accordion

  • Thread starter Thread starter wx4usa
  • Start date Start date
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
 
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.
 
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?
 
The rows that are hidden/displayed won't change until you change the autofilter
criteria. It's not automatic.
 
Back
Top