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
Bookmarks