Delete rows on multiple sheets if cell contains specific criteria.

Hi All,

I've been having a problem trying to write some code to delete rows on multiple worksheets. I basically have 5 sheets out of 8 in a workbook where I would like all rows that contain either 'Booked' or 'Not booked' in column G to be deleted. Each worksheet has a different number of rows however it will always be column G that contains the criteria.

I'm sure they may be a simple way around this, could anyone help?

Thanks!

Maybe:

Please Login or Register  to view this content.

HI John,

Thanks! It seems to work on the first sheet by deleting the rows with 'Booked' in them. However how simple would it be to add another criteria to delete those with 'Not booked' too. Also for the other sheets (column g cells are blank at the moment) it just deletes the headings row at the top and leaves the rest of the data.

Maybe:

Please Login or Register  to view this content.

Hi John, thanks again but this time around the code doesn't seem to work at all

Can you provide a sample file with some dummy data, where it doesn't work on?

Sure, I've attached a dummy version where in this case I want only data with booked or not booked in column G of the first 3 sheets to be deleted.

Thanks!

This seems too work on your sample.

Please Login or Register  to view this content.

This works perfectly however there is a slight problem, if column G contains nothing on the sheet than it will simply delete the headings row. For example if one of the sheets does not have a 'booked' or 'not booked' cell in column G... the headings row will be deleted. Not quite sure why this is the case. Thanks again!

Try this:

Please Login or Register  to view this content.

Same situation again, is there a way to put some code in that will ignore the row if it is a blank and move onto the next? Issue only seems to come up if the cell is blank and this may be the case in mt spreadsheet.

Thanks!

Ok, maybe:

Please Login or Register  to view this content.

Thanks, this one works perfectly now. I have one more question if that's ok... I would like to assign this macro to a button on a dashboard at the front of the workbook. However this stops the macro from working (It only works if I run it from the first of the pages I would like rows deleted from. Any simple way to do this?

It shouldn't?

You need to change the Sheet names within the Array to reflect the Sheets you want it to run on.

Please Login or Register  to view this content.

You're right it shouldn't have been. Closed the workbook and opened it again and it seemed to work fine. Thanks again!

You're welcome. Glad to help out and thanks for the feedback. Please mark this thread as SOLVED.