Hello to all! This is part 2 of Insert Row Based on Consecutive Qualifiers. The code provided for inserting the rows works perfect.
The data represents time card corrections. Instructions tab is included to help you understand the challenges I am faced with. I am uncertain as to what is the best way to approach this.
The time-card corrections fall in one of the four categories and the goal is to get the data in a CC From followed by a CC To. For every CC From transaction it should be followed by a CC To transaction.
1. Charged to the wrong Project Code
2. Didn't charge time when they actually worked. {Reflects transactions for which there is no CC From to copy/paste - Nothing but CC To(s) exist}
3. Charged time when they didn't work. {Reflects transactions for which there is no CC To(s) to copy/paste - Nothing but CC From(s) exist}
4. Charged the wrong hours (increase/decrease of hours only).
I look forward to hearing from you. You help is very much appreciated. In a further dicussion posted I provide an avenue of approach. I am eager to hear your thoughts.
Thanks - Cora