hide row if "y" in column m

[stevekirk]

hi,



what i would like to do is hide a row if i put a "y" in that row in column M
there will be a least 500 rows

thanks steve

[royUK]

Why not use AutoFilter?

[stevekirk]

roy,

i am working in china they do not know much about excel
a button would be good

steve

[royUK]

use the macro Recorder to get the basic autofilter code, then post back if you need help to finish the code.

[[email protected]]

Roy,

Would a formula in the last column ofo the row do it? I don't know the syntax, but it seems like if there was a formula, the row would auto hide if someboy put a "Y" in column M. Somehting like:

=IF(M1="Y",row.height=0,row.height=12.25)

I know the row.height is wrong. I'm just curious myself.

[royUK]

A formula or function cannot usually physically affect a sheet.

A VBA solution could involve a loop to find & hide all rows where Y is entered or autofilter which can be automated with VBA. The autofilter IMO would be the most efficient

[[email protected]]

Thanks for clearing that up Roy. Have a good one.

[martindwilson]

perhaps something like this.
i hid the auto filter in last column
used =m1 dragged down and filtered that.

[stevekirk]

sorry for the late reply
that works great
thanks again
steve