Populating data to right based upon cell criteria

  • Thread starter Thread starter Potsy
  • Start date Start date
P

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
 
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
Click to expand...

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.
 
Back
Top