Good Day,
Here is a challenge for the masters of excel (EXCELITES). I have a workbook with multiple sheets, all are formatted the same way and require the said information (SEE BELOW).
<tbody>
A
B
C
D
E
F
G
I
2
NAME
JOHN BROWN
OFFENCE
LARCENY
3
DOB
27-3-72
4
OCCUPATION...