I am looking for a Microsoft Excel spreadsheet to be designed.
It will be used for task management and planning. I am currently using a basic word document and have attached a screen shot to show how I need the spreadsheet to work.
I am open to suggestions about if you think Excel is the right program to be using or any more design features that might help the spreadsheet work.
If you think you would be able to design this for me or have any ideas on what I am after and / or better way to make it work I look forward to hearing from you.
Would anybody who reply's to this job please include full details of what you can offer and also how long it will take to complete please.
Please see the Detailed requirements section for more details.
## Deliverables
The Header needs to include a small logo that I will supply, Fixed Title (PLANNER & CONTACT LOG SHEET) and an editable section for name, address, postcode and phone number.
I currently need 6 columns:
**Date,
**I would like this to bring up a calendar Instead of free typing it on every new task.
**
Contact,
**Needs to be left so I can free type.
**Phone / Email,
** Needs to be a drop down so I can choose either or.
**Subject,
** Needs an automatic numbering rule see the attached document for an idea of how it needs to work, then after the number I need the option to free type.
**Conclusion,
** Needs to adopt the same numbering pattern as the Subject column, see the attached document for an idea of how it needs to work. Then after the number I need the option to free type.
**Follow up,
** Needs a drop down box so I can choose Yes or No.
If I choose no I need it to add the following text "No - See ()" so I can just input a reference number between the brackets like in the screen shot supplied.
If I choose yes I need it to add the following text in Colour Model (RGB) Blue "Yes - " then allow me to free type after the space. See the screenshot for more info. I don't know if it is possible but I would like to be able to link a task from this column to my outlook diary if it is possible.