Automated tasks for a Project Communications plan template

  • Posted:
  • Proposals: 0
  • Remote
  • #694095
  • Expired
  • 0


Experience Level: Intermediate
Hello Nisha,

I have come across your profile and hope you can help me with this.
I have created a very simple Project communications plan template, please see attached.
I would ideally like this to work like a task reminder spreadsheet doing the following functions:
* The "Time Status" field “ to automatically function as a daily update and display the statuses( as shown below the table) depending on the issue date is. 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” and will change accordingly.
* If possible can a command button be created to run a macro that moves data into the "Message issued" tab once a message has been sent. I have already added the fields i would like to be moved across however i'm not sure how it would be removed from the "Project comms plan" tab. At the moment i have written a function that copies the same data on the 2 worksheets, but if i wanted to remove a row in the "Projects comm plan" it causes some issues in the "Message issued" tab.

I hope this all makes sense, let me know your proposal and we can take it from there.

Many thanks,

Deanne Davis

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.