Insert Row Depending on Cell Value

[BazzaBoy]

I have a worksheet in which the cell in column B of the membership list contains a 'Y' or a 'N', depending on whether someone is a member or not.

I want to write a macro, whereby, on clicking the macro button, only rows with a 'Y' will show. Rows with a 'N' will be hidden.

Any help appreciated.

[jaslake]

Hi BazzaBoy

I'd think you may need two buttons. See attached.

John

[BazzaBoy]

Thanks jaslake,

I am a non-programmer. So, I only know how to work with simple macros. Can you show me how you have connected the command buttons to the VBA code?

I already have the following code under sheet1:

Please Login or Register  to view this content.

Can we not just do it with sinple macros and macro buttons?

Thanks.

[davesexcel]

The code you have displayed goes into the worksheet module not a regular module, you cannot attach a button to a worksheet module.
Right click on the sheet tab and select view code, copy and paste the code there. When there is a change in "B8:B100,G8:J100"
The code will activate.

[jaslake]

Hi BazzaBoy

The code I provided in the attached workbook does this

on clicking the macro button, only rows with a 'Y' will show. Rows with a 'N' will be hidden

If you need something further, you'll need to describe/show what it is you need to do.

John

[BazzaBoy]

Thanks davesexcel ,

All sorted out.

You may mark this thread as SOLVED.

[jaslake]

Must be late. I'm a little confused.

[JBeaucaire]

You may mark this thread as SOLVED.

That's your job, hehe. Click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.