T
Txlonghorn76
Last week I was I had asked for a formula that would give me the yesterday's
numbers for an employee that pulled to a Summary Sheet from a table in
another worksheet. I was given this awesome formula:
=index(tbl,match(Thisday-1,Dates,0),match(Tgt,Names,0))
I would like to tweak this formula just a bit so that it pulls the running
sum for the month instead of just 1 day.
Summary sheet:
09/10/2008
Name Yesterday's numbers MTD Numbers
AAA
BBB
CCC
DDD
Table to pull data from:
AAA BBB CCC DDD
09/09/2008 30 31 32 33
09/10/2008 34 35 36 37
09/11/2008 38 39 40 41
09/12/2008 42 43 44 45
09/13/2008 46 47 48 49
09/14/2008 50 51 52 53
numbers for an employee that pulled to a Summary Sheet from a table in
another worksheet. I was given this awesome formula:
=index(tbl,match(Thisday-1,Dates,0),match(Tgt,Names,0))
I would like to tweak this formula just a bit so that it pulls the running
sum for the month instead of just 1 day.
Summary sheet:
09/10/2008
Name Yesterday's numbers MTD Numbers
AAA
BBB
CCC
DDD
Table to pull data from:
AAA BBB CCC DDD
09/09/2008 30 31 32 33
09/10/2008 34 35 36 37
09/11/2008 38 39 40 41
09/12/2008 42 43 44 45
09/13/2008 46 47 48 49
09/14/2008 50 51 52 53