LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Hiding rows containing zero in certain column on multiple sheets

Hiya - I hope you can help

I have a table on which I would like to hide selected rows should the
value in a certain column be zero (say, I would like to hide rows
5,10,16,17 & 18 if their value in column M is zero). I have the table
on multiple worksheets (say Sheet1, Sheet2, Sheet3 & Sheet4). The
table is exactly the same on each sheet, but the data is different so
different rows will be hidden.

How can I do this with coding? I am more or less a novice on this. My
experience is pretty much limited to using the macro recorder. Any
help would be very much appreciated. Thanks!!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hiding rows based on a column value Mark Hansen Excel Programming 6 April 9th 06 06:34 PM
Hiding/Unhiding multiple sheets in VBA? Simon Lloyd[_660_] Excel Programming 2 November 14th 05 10:57 AM
Hiding/Unhiding sheets and rows (An easy one for most of you....) Dean Goodmen Excel Programming 2 February 24th 05 11:06 PM
Hiding/Unhiding sheets and rows (An easy one for most of you....) Dean Goodmen Excel Programming 3 February 23rd 05 08:46 AM
Cut rows from one sheet into multiple sheets based on a criteria in first column pepino13 Excel Programming 1 September 11th 03 09:52 PM


All times are GMT +1. The time now is 03:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"