VBA Code to look for specific text value and delete row

Hello,

I have an absence tracker containing a number of sheets and would like some VBA code to perform a certain task.

- "current 6 months" sheet holds absence data in the current 6 month rolling period. I have a code which moves rows of data between sheets depending on absence start date.
- "master data" sheet is regularly refreshed with system data to keep things in the report, like job titles etc up to date.

I would like a piece of VBA code I can assign to a button on the ribbon which does the following:

Current 6 months sheet

Column B tells me whether the person is Active, inactive or terminated. This information is gained from a vlookup to the "master data" sheet.

I would like a piece of code which I can assign to a button on the ribbon (so we have freedom of choice when the code is executed), which looks at column B and anywhere where it says "terminated", the code will delete the entire row, effectively removing all terminated people from the absence report.

Kind Regards

Hi Chris

How about this code:

Please Login or Register  to view this content.

zeddy

Hi Chris

The way I wrote that code was to apply your status-filter to whatever is currently filtered.
So, for example, if you wanted to filter first by choosing say a Job Title or Location etc etc etc and then remove the Terminated status records you could do so.

zeddy

Hi Chris

I assume you could copy that code into a new module, and then assign it to a button on your Ribbon as you wanted.

zeddy

Hi Chris

how about this then..

Please Login or Register  to view this content.

I could put some more error-checking in the code if you need it, but I was leaving a bit for you!

zeddy

Hello,

I'm currently learning VBA and have just finished learning what Object.Method (noun.verb) is and what parameters := (adverbs) and properties = (adjectives) are.

So, as you might be able to tell, a complete beginner!

Thanks very much for this!

Kind Regards
Chris