Hi.
I've had a look on line but all the Macros are too complicated. I am looking for the following
Looking for an email with the title
West Availability Report – 0500hrs Tuesday 25th July 2017 ( the date changes daily)
to extract information in it (a table to be exact) and move it to Excel
<tbody>
</tbody>
Any help is appreciated.
I've had a look on line but all the Macros are too complicated. I am looking for the following
Looking for an email with the title
West Availability Report – 0500hrs Tuesday 25th July 2017 ( the date changes daily)
to extract information in it (a table to be exact) and move it to Excel
<o></o> | Units in Class<o></o> | Stopped<o></o> | Available<o></o> | Diagrams<o></o> | Balance<o></o> | Stopped Units<o></o> |
Class 143<o></o> | <o></o> | <o></o> | <o></o> | <o></o> | | <o></o> |
Class 150/0<o></o> | <o></o> | <o></o> | <o></o> | <o></o> | <o></o> | |
Class 150/1<o></o> | | <o></o> | | | <o></o> | <o></o> |
Class 150/2<o></o> | | <o></o> | | | <o></o> | <o></o> |
Class 150/9<o></o> | <o></o> | <o></o> | <o></o> | <o></o> | <o></o> | |
Class 153<o></o> | | <o></o> | | | <o></o> | <o></o> |
Class 158 2-Car<o></o> | <o></o> | <o></o> | <o></o> | <o></o> | <o></o> | |
Class 158 3-Car<o></o> | | <o></o> | <o></o> | | <o></o> | <o></o> |
Class 166<o></o> | <o></o> | <o></o> | <o></o> | <o></o> | <o></o> | |
Hired-in Resources<o></o> | <o></o> | <o></o> | <o></o> | <o></o> | <o></o> | <o></o> |
TOTALS<o></o> | | | | | <o></o> | |
Any help is appreciated.