ssincerely
New Member
- Joined
- Aug 27, 2012
- Messages
- 31
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>
</tbody>The other cells are occupied or merge for other info etc.....
What I now want is a Mastersheet to generate with the information in RED ABOVE in rows (SEE BELOW)
<tbody>
</tbody>
Thanks in advance for any assistance that can even lead me in the right direction....Respect and Jah Love
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).
A | B | C | D | E | F | G | I | |||
2 | NAME | JOHN BROWN | OFFENCE | LARCENY | ||||||
3 | DOB | 27-3-72 | ||||||||
4 | OCCUPATION | CARPENTER | ||||||||
5 | ADDRESS | 123 LOVE LANE | ||||||||
6 | TELEPHONE | 923-1723 | ||||||||
DATE REPORTED | LAST DATE | NEXT DATE | ||||||||
20 | 31-3-18 | 24-3-18 | 17-5-18 | |||||||
<tbody>
</tbody>
What I now want is a Mastersheet to generate with the information in RED ABOVE in rows (SEE BELOW)
A | B | C | D | E | F | G | H | I | ||
1 | NAME | DOB | OCCUPATION | ADDRESS | TELEPHONE | OFFENCE | DATE REPORTED | LAST DATE | NEXT DATE | |
2 | JOHN BROWN | 27-3-72 | CARPENTER | 123 LOVE LANE | 923-1723 | LARCENY | 31-3-18 | 24-3-18 | 17-5-18 | |
3 | ||||||||||
4 |
<tbody>
</tbody>
Thanks in advance for any assistance that can even lead me in the right direction....Respect and Jah Love