Populating data to right based upon cell criteria

[Potsy]

Hi

I have data in a cell (L7) that calculates total project length in
weeks and in (L9) I have total hours.

Using the start date the excel sheet is automatically posting calendar
dates of project (i.e start date +1, +2 etc), however I would like to
show from columns (O7-AN7) below to look at cell (L7) to establish
total weeks and then divide total hours (L9/L7) across each column up
until the project finishes in weeks based upon value in (L7).

Obviously only want to do this as far as total project duration i.e.
if project in L7 is only 8 weeks in duration and there are 800 hours
in L9 it would return a result of 100 hours from O& for 10 columns
only.

Hope this makes sense. Any help appreciated.

Stuart

 

[Potsy]

Hi

I have data in a cell (L7) that calculates total project length in
weeks and in (L9) I have total hours.

Using the start date the excel sheet is automatically posting calendar
dates of project (i.e start date +1, +2 etc), however I would like to
show from columns (O7-AN7) below to look at cell (L7) to establish
total weeks and then divide total hours (L9/L7) across each column up
until the project finishes in weeks based upon value in (L7).

Obviously only want to do this as far as total project duration i.e.
if project in L7 is only 8 weeks in duration and there are 800 hours
in L9 it would return a result of 100 hours from O& for 10 columns
only.

Hope this makes sense. Any help appreciated.

Stuart

Don't worry think have managed to do it with an 'if statement'
reporting a zero as a false and then running a autofilter masking
zeros in order I can graph.