I normally don't ask for help on forums, especially when I know that I am WAY out my league but if your feeling kind, feel free to contribute!
I need to compare two cells (D2 and D3) and if they match a certain result then copy some cells associated to them to a new worksheet, and then move on to the next row and repeat until there is no more data (Blank Cells).
So lets say in cell D2 I have "Personal" and in D3 "Break", if that statement is true I need to move cells A2 through AJ to another worksheet. Then the macro would move on to scan cells D3 and D4, If there was no match (Say D3 "Break" and D4 "AUX") then it would just move on until there was a blank cell.
Again I know the help you are giving me is free so I really appreciate it!
If you want to see a pic of the raw data here is the link.