L
Legion_c18
I have multiple worksheets, each with roughly 5 rows on them in the same
locations. What I want to do is, when a cell in column X among those 5 rows
equals 0, hide that row. In other words, say rows 1 thru 5 have the
following numbers in column X: 1, 4, 0, 4, 7. I'd like Excel to hide row 3.
The thing is, the numbers change constantly because they are generated by a
vlookup formula. So, row 3 may be hidden on one sheet, while row 5 is hidden
on another.
I know similar questions have been asked many times and the answer usually
involves using a macro. The problem is, I have never worked with macros and
would really appreciate a walk through. I am using Excel 2007. Please let
me know if I need to clarify my question in any way.
locations. What I want to do is, when a cell in column X among those 5 rows
equals 0, hide that row. In other words, say rows 1 thru 5 have the
following numbers in column X: 1, 4, 0, 4, 7. I'd like Excel to hide row 3.
The thing is, the numbers change constantly because they are generated by a
vlookup formula. So, row 3 may be hidden on one sheet, while row 5 is hidden
on another.
I know similar questions have been asked many times and the answer usually
involves using a macro. The problem is, I have never worked with macros and
would really appreciate a walk through. I am using Excel 2007. Please let
me know if I need to clarify my question in any way.