Our address is in message header.
We note you have two addresses, one with AOL and one with COX.
Abstract of one of our earlier response to you is appended below please

No need to see your spreadsheet now.

We believe this is what you need to do:

Col A is list of projects,

Col B is type of distribution (front loaded, end loaded, pro_rate)

Activate a macro

if Bi is front loaded, do procedure "front loaded"

if Bi is end loaded, do procedure "end loaded"

if Bi is pro_rate, do procedure "pro_rate"

Obviously, you need to create the procedures accordingly.



Cheers!



"vitorjose" wrote in message
oups.com...
Thanks for your help - how do i get the file to you
PY & Associates wrote:
Can we have a look at the spreadsheet please?

"vitorjose" wrote in message
oups.com...
Hello All

I have a spreadsheet which lists a set of projects in column A with
months across the top in Row 1. Each project has a total cost and
duration. My challenge is to distribute the cost across the duration
of the project according to a pre determined pattern. Different types
of projects will have different types of cost distribution, one type
front loaded and another back loaded, etc. I have also created a
table
which lists different distribution patterns based on standard project
duration of 12 months. A drop down list is provided in Col B to select
the appropriate distribution pattern. The problem is that two
projects may have the same distribution of costs but different
durations. Is there a way for me to compress / or expand the
distribution pattern and then apply the resulting values to the
project
cost and distribute the costs over the appropriate time period.


Thanks in advance for your help

Vitor Jose