Deleting rows based on criteria

Hi there,

I wonder whether you can help, I have a spreadsheet that has a number of sheets containing user names and data in rows.

I currently have a front sheet with a marco that allows me to add a new user to all the sheets.

However, every time I want to remove a user I need to go into each sheet and delete the row.

If I type the name I want to delete on the front sheet, is there a marco that can copy the name from the front sheet find it in all the other sheet and delete the rows where the name appears?

Thanks

Mark

Yes, it does.

I would do something like this, so even if the username is in a different column it will still find it.

Please Login or Register  to view this content.

Thanks

When you say "user name" can this be a cell reference? Or will this need to be an actual name?

Either, you can place the username in the code or you could point it at a cell that contains the username like this:

Please Login or Register  to view this content.

The above would look for the username in cell A1 and you can change this to any cell you like.

This works a treat, many thanks!!

However, it does seem to delete the row on the front sheet where I input the name aswell. Is there anyway to omit a sheet?

This is the code in action:-

Please Login or Register  to view this content.

Yep you can omit a sheet like this:

Please Login or Register  to view this content.

That's great!!

Many thanks for your help!!