From the following table I want to be able to answer 3 questions with
VBA
a. From the cumulated % Column. By what date will I reach 30%
or
b. From the Running Total Column. By what date will I reach 3,000
or
c. From the Date Column. What will be the running total & % by October
1
..
Note : the Date column is in Date Format
Help appreciated
..
Date Cost1 Cost2 Total Run Ttl %
7/27/2010 12 600 612 612 10.7
7/28/2010 1 50 51 663 11.6
7/30/2010 4 200 204 867 15.2
8/25/2010 10 500 510 1,377 24.1
8/26/2010 7 350 357 1,734 30.4
8/27/2010 12 600 612 2,346 41.1
8/28/2010 13 650 663 3,009 52.7
9/30/2010 10 500 510 3,519 61.6
10/1/2010 7 350 357 3,876 67.9
10/2/2010 12 600 612 4,488 78.6
10/3/2010 24 1,200 1,224 5,712 100.0
Grand Total 112 5,600 5,712