B
Barb
I am trying to populate a table based upon data in another table. Based upon
what is entered into two fields
Input
Review Yr: 2009 (k7) Review month 1 (M7)
Results
Month Util. % Month Util. %
Jan-08 0.0% Jul-08 65.0%
Feb-08 32.0% Aug-08 85.0%
Mar-08 42.0% Sep-08 95.0%
Apr-08 45.0% Oct-08 100.0%
May-08 32.0% Nov-08 25.0%
Jun-08 35.0% Dec-08 45.0%
list of values
row / col B C
109 Dec-07 45.0%
110 Jan-08 0.0%
111 Feb-08 32.0%
112 Mar-08 42.0%
113 Apr-08 45.0%
114 May-08 32.0%
115 Jun-08 35.0%
116 Jul-08 65.0%
117 Aug-08 85.0%
118 Sep-08 95.0%
119 Oct-08 100.0%
120 Nov-08 25.0%
121 Dec-08 45.0%
122 Jan-09 35.0%
123 Feb-09 65.0%
124 Mar-09 95.0%
125 Apr-09 22.0%
126 May-09 26.0%
127 Jun-09 28.0%
128 Jul-09 30.0%
129 Aug-09 32.0%
130 Sep-09 36.0%
131 Oct-09 38.0%
132 Nov-09 40.5%
133 Dec-09 65.0%
what is entered into two fields
Input
Review Yr: 2009 (k7) Review month 1 (M7)
Results
Month Util. % Month Util. %
Jan-08 0.0% Jul-08 65.0%
Feb-08 32.0% Aug-08 85.0%
Mar-08 42.0% Sep-08 95.0%
Apr-08 45.0% Oct-08 100.0%
May-08 32.0% Nov-08 25.0%
Jun-08 35.0% Dec-08 45.0%
list of values
row / col B C
109 Dec-07 45.0%
110 Jan-08 0.0%
111 Feb-08 32.0%
112 Mar-08 42.0%
113 Apr-08 45.0%
114 May-08 32.0%
115 Jun-08 35.0%
116 Jul-08 65.0%
117 Aug-08 85.0%
118 Sep-08 95.0%
119 Oct-08 100.0%
120 Nov-08 25.0%
121 Dec-08 45.0%
122 Jan-09 35.0%
123 Feb-09 65.0%
124 Mar-09 95.0%
125 Apr-09 22.0%
126 May-09 26.0%
127 Jun-09 28.0%
128 Jul-09 30.0%
129 Aug-09 32.0%
130 Sep-09 36.0%
131 Oct-09 38.0%
132 Nov-09 40.5%
133 Dec-09 65.0%