VBA automatically delete row if cell = 'Y'

[charlesgy]

I'm trying to find a code that will allow me to input a 'Y' and allows a row on the next sheet to stay populated.

but if the cell is empty I want the entire row to be delete.

so if c23 = Y
row 11 stays

if c23= (blank) or N
row 11 is deleted.


I will need a very similar code for around 50-60 cells, and with a corresponding row to be deleted/kept.

 

[Akuini]

I will need a very similar code for around 50-60 cells, and with a corresponding row to be deleted/kept.

Where is the ‘around 50-60 cells’ located? C23:C83?

 

[charlesgy]

they are scattered all over the sheet.
there isn't any logical order.

is there a way I can copy the document into this thread?

 

[Akuini]

You can post small screen shots of your sheet using MrExcel HTML Maker or another add-in.
See this:
Attachments

or you can upload your workbook somewhere, maybe to dropbox.com

 

[charlesgy]

so the first image is the cell's I need to have a 'Y' or 'N'

the second image is the rows I wish to be deleted if the cell is 'N' or just left blank

 

[charlesgy]

Pasteboard — Uploaded Image

Pasteboard — Uploaded Image

 

[Akuini]

I don’t see any “Y” or “N”. Are they should be in col C,G,K only?
And do you have merged cells in your data set?

 

[charlesgy]

I haven't inputted any 'Y' or 'N' at the moment but yes they will be in col C,G and K.

and there is merged cells on the sheet.

but non of the cells that I'm using for this are merged.

 

[Akuini]

if c23= (blank) or N
row 11 is deleted.

So if “N” found in row 32 (in col C,G or K) then row 20 (in the other sheet) must be deleted?
What would happen if say C32 = “Y” and G32 = “N”?

 

[charlesgy]

so each cell has its own row dedicated to it, so if C32 = 'Y' row 20 will stay
G32 is linked with row 49 so that would be deleted.