Automatically add/show/hide rows that have (or have no) data?

wx4usa@gmail.com

Guest

Posts: n/a

28th Dec 2006

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

« Run macro on refresh data (pivot table) | repeat macro for added items »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to Show/Hide Columns or Rows with no data via VB	Kev - Radio Man	Microsoft Excel Programming	4	31st May 2010 06:58 AM
Hide/Show Rows based on Cell Value with Data Validation	Shelly	Microsoft Excel Programming	3	4th Jan 2008 11:01 PM
Hide Rows - copy and paste only rows that show	=?Utf-8?B?QWNjZXNzMTAx?=	Microsoft Excel Worksheet Functions	3	1st Mar 2006 12:39 AM
Hide rows automatically	=?Utf-8?B?a2lt?=	Microsoft Excel Misc	1	14th Sep 2005 02:23 PM
How do I automatically hide rows	=?Utf-8?B?Um9iUm95?=	Microsoft Excel Misc	8	2nd Feb 2005 01:12 PM