Hi Mdn,
Sure it's possible, (almost) everything is possible with VBA but the problem is you first sentence under the Hi guys,
We can start explaining but that will abracadabra to you and any modifications or exceptions means you'll be completely dependent of some guy across the www to help you at all times.
All you need is a macro that starts at the last row and loops back until row 1 and on the way up if checks if the value in column B answers to the criteria to be deleted.
You have to do this in reverse order because the row counter would get messed up if a row ' dissappears'
the vba code would look something like this
But it's not tested , I'll see if I can find something and of course you will have to 'tell' the macro to process all the worksheets where applicable.
My first tip: start learning VBA there many sites with tutorials and code samples
Bookmarks