For reporting purposes, I want to define a range to work with.Column 'A' contains an 8 digit numbering system.Example; P1107001Digit 1 = Marker (P = Proposal)Digit 2-3 = Year (11 = 2011)Digit 4-5 = Month (07 = July)Digit 6-8 = Job Sequence #I can isolate the year by using;
But I want to define a range from the first occurrence to the last occurrence of the target year (or month), so I can further manipulate/extract the desired report data.Your suggestions would be greatly appreciated.Regards,