Spend profile

Closed
stan - Jul 28, 2010 at 06:12 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 30, 2010 at 08:04 AM
Hello,

I am trying to spread a value over a date range (spend profile).

Esentially

Col A = Start Date of an Activity
Col B = End Date of an Activity
Col C = Value to replicate across Col D, E, F etc

The value replicated must fit within the date range of Col A and Col B. So the respective columns D, E etc are example 01/01/10, 02/01/10 etc

What is the best way to go about this?


1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 30, 2010 at 08:04 AM
What did you meant by "Col C = Value to replicate across Col D, E, F etc "

Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
0