Compare Column Delete if no Match Macro

Hi, I have a Workbook that I am adding some features too and VBA is not my forte. But I am a quick learner. So looking for some guidance on the following process of my code.

I have Column A which hosts a standard data set of information we might find in Column B. An example:

Intraday	Personal		52
Personal Vacation	Excused Unpaid		19
	Absence		47
Tardy
Absence		Total	63
Total

As you can see from this example Column B often might even contain just a portion/string of the data from Column A.

The goal here is to match if Column B is in Column A, if not delete Column A shift cells up, Check again.... Repeat until the word "Total" Matches from Column C to Column A.


The end result should look like:

Personal Vacation			52
Excused Unpaid			19
Absence			47
Total			63

Thanks vankheet, but I have reattached my book and posted it for you. Looking through your macro not sure it will fit my situation. I hope you will see why once you see more data.

Maybe it will also make the situation more clear as to what my goal is/what I'm trying to do. I have added more data onto the data set in sheet1. The goal would be to take that data and make it look like sheet 3, on sheet 2 of course. There will not be headers like there currently is on sheet3.

avatar 141002test.xlsm

FYI still looking for some guidance in how to build a macro to do this in vba. If anyone could give me some ideas on how it should function or could help break down what venkat did with his so I can better understand why it won't work on the full data set it would be greatly appreciated. VBA leaves me a little more stumped than working with java

Got some more time to play around with this project... Here is another sample of what I am trying to do, keep in mind my vba skills are tiny at the moment...

Please Login or Register  to view this content.