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!!
|