I need a dynamic excel sheet for project leads.
- or -
Post a project like this- Posted:
- Proposals: 7
- Remote
- #1318442
- Awarded
Description
I need help organising a confused and limited excel project list.
I need to be able to input details of multiple potential projects that specify an expected delivery date.. But, if that delivery date moves, once i have adjusted expected date, the information of project to move in to the new month automatically.
I then want to be able to see the total potential order value for each month, as well as other parameters.
Chris D.
100% (2)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Please could you share as example file which you have now
-
Hi Chris,
Would it be possible to send me a little more detail about what you require. I will then be able to provide an accurate quote for you.
Thanks,
MarkChris D.12 Oct 2016Hi Mark,
I work on a lot of projects that have their deadlines adjusted. I need to be able to input data such as Customer, Country, Product, Sales price, Order date, delivery date.
At present I have to cut and paste the project into the new month, re-do the months calculation for total turnover etc. Its all manual.
I am looking for an excel sheet that if i adjust the delivery date, all data will move into that month, and be added, or subtracted from that months total sales value.
I am looking for something that is easy for my colleagues to see, accurately what projects and products will be sold by month, over the financial year.