Hide rows if cell value is less than another cell value

[nwpassage]

I have a worksheet with a bunch of rows...

I'd like to be able to hide the entire row if the value in cell Nx is less than the value in Mx.

Is this doable in VBA?

[Leith Ross]

Hello nwpassage,

Change the cell "N1"and "M1"to what you want to use.

Please Login or Register  to view this content.

How to Paste a Macro into a Worksheet

1. Copy the macro with Ctrl+C.
2. Right Click the Sheet Tab at the bottom of the worksheet.
3. Click View Code
4. Paste the macro into the module with Ctrl+V.
5. Save the macro using Ctrl+S

[StuCram]

Here's a macro to do the job: (Assuming the data starts on row 4)

Please Login or Register  to view this content.

The commented macro code and sample Excel file is attached…