Task reminder for a Project Communications plan template

  • Posted:
  • Proposals: 4
  • Remote
  • #695197
  • Awarded
Ashley H.
Les K.Surya G.Paul S. have already sent a proposal.
  • 0

Description

Experience Level: Intermediate
Estimated Job duration: less than 1 week
Purpose – This template will be used to record all communications due to be sent out for each IT project. In other words I would like it to work as a task reminder.
Two worksheets have been created titled “Project Comms Plan” and “Message issued. “Project comms plan” will contain all messages due to be sent out
“Message issued” will contain messages already sent

• I would like the “Time Status” field in “Project comms plan” to automatically function as a daily update and display the reminders (shown below the table) depending on the issue date. For e.g. if a message is due to be issued on Wednesday 25 February 2015 then the Time Status would display “Within a week” etc.
• If possible I would like a command button created labelled “Complete” that when selected will move data across to the “Message Issued” tab once a message has been sent out and completed.

I have attached a copy of the template for you to review, i am also open to any suggestions

P.S. I currently use Excel 2010 and Windows 7 Operating system

Regards,

Deanne

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.