HIDING ROW 2

[xsubzeroz]

Does anyone know if it is possible to have, if cell for example c8 has letter "C" then to hide that row. Or is there any other way it can be done so that if cell contains data then to hide row automatically.

 

[SkipVought]

Hi,

You could use the AutoFilter with a Custom Criteria for that column.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[xlbo]

Other than that - no way except for VBA

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[xsubzeroz]

It is closer to what I need but still no exactly to what I was looking for. I have an issues log where I put date as a target for completion for each task. When I put a completion date in cell, I have conditional format to shade row but these rows build up and some issues have been closed and I don't care about them. So I would like to automatically hide any rows the have completion date entered. Would something like this is possible??

 

[xsubzeroz]

xlbo, is this a very large code for VBA? Would it be very hard to do it?

 

[dyarwood]

Turn on the macro record button. To an AutoFilter for not equal to C in the column and then turn off the macro recorder. That should give you the code to hide all the rows.

 

[xlbo]

easiest way is as dyarwood has instructed

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[KenWright]

Data / Filter / Autofilter / Blanks on the completion date column should give you what you want I think.

Regards
Ken..............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------