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