Variance reports ( from the variance file)
Use last weeks e-mail as a template and recipient list
Just change the date in the subject title
- ANZ
Hide any unused rows
Snip report for WC, EC and NZ
Paste into e-mail and send
- ASIA
Hide any unused rows
Snip report for Asia
Paste into e-mail and send
Utilisation reports (from the schedules)
Use last weeks e-mail as a template and recipient list
Just change the date in the subject title
- WC schedules
Hide cols A & B
Hide any previous weeks cols, leave all of the following month
Hide any row that does NOT have a Pink U (Bench)
Snip and paste into E-mail
- EC
Hide cols A & B
Hide any previous weeks cols, leave all of the following month
Hide any row that does NOT have a Pink U (Bench)
Snip and paste into E-mail
- Asia
Includes China, Hong Kong and Singapore
Do not hide any cols from A-F
Hide any previous weeks cols, leave all of the following month
Hide any row that does NOT have a Pink U (Bench)
For Asia also include the summary in rows 183-217 in your snip