H
Haggisdog
I am trying to figure out a way in which I can reference a table whic
contains a series of cells which indicate how long it takes for
person to progress from one level to the next.
Estimated Time to move from one level to the next
Level One 0
Level Two 2
Level Three 3
Level Four 4
Level Five 5
I want to use these cells to develop a monthly schedule which wil
automatically adjust itself to reflect any changes to the table above.
The values in the first mopnth reflect the 'starting point' from whic
the schedule is developed. As you can probably tell. the table need
to recognize when a person progresses from one lelve to the next an
then applies the length of time necessary to achieve the next level i
the progression:
Name Start Jan Feb Mar Apr May Jun Jul
Level One 2 2 2
Level Two 5 5 5 7 2 2
Level Three 0 0 0 0 5 5 7
etc.
I was thinking that offset and match might help me do this but I a
beginning to doubt that a formula will work at all and it might requir
some VBA (which I know nothing about).
Any help would be appreciated (even if it's simply sympathy for wha
I'm facing
Thanks in advance!
Bryan Campbel
contains a series of cells which indicate how long it takes for
person to progress from one level to the next.
Estimated Time to move from one level to the next
Level One 0
Level Two 2
Level Three 3
Level Four 4
Level Five 5
I want to use these cells to develop a monthly schedule which wil
automatically adjust itself to reflect any changes to the table above.
The values in the first mopnth reflect the 'starting point' from whic
the schedule is developed. As you can probably tell. the table need
to recognize when a person progresses from one lelve to the next an
then applies the length of time necessary to achieve the next level i
the progression:
Name Start Jan Feb Mar Apr May Jun Jul
Level One 2 2 2
Level Two 5 5 5 7 2 2
Level Three 0 0 0 0 5 5 7
etc.
I was thinking that offset and match might help me do this but I a
beginning to doubt that a formula will work at all and it might requir
some VBA (which I know nothing about).
Any help would be appreciated (even if it's simply sympathy for wha
I'm facing
Thanks in advance!
Bryan Campbel