C
Clif Davis
My problem is this, I have two columns that both have data based on 48
intervals for a day. (Half-hour time frames).
Column A is projected numbers for the day. Column B is real data collected
which is populated each half hour with supplied collected data.
In row 49, A49 has a total for the forecasted information which is good only
for end of day information. Cell B49 has subtotal information from each
interval during the day, changing each half hour.
I need a macro that will place a cell under A49 (A50) which will give the
subtotal of forecasted data. I.E if it is 2am there would be 4 cells with
data in "B" and a corresponding subtotal in B49 and/but there would be a
subtotal in A49 subtotaling the entirety of "A". All 48 entries. I need a
subtotal of only the cells that match the cells in "BE" that are >0.
I hope I have made this example clear. Please feel free to request further
information should it be needed.
Clif Davis
Please feel free to contact me directly.
intervals for a day. (Half-hour time frames).
Column A is projected numbers for the day. Column B is real data collected
which is populated each half hour with supplied collected data.
In row 49, A49 has a total for the forecasted information which is good only
for end of day information. Cell B49 has subtotal information from each
interval during the day, changing each half hour.
I need a macro that will place a cell under A49 (A50) which will give the
subtotal of forecasted data. I.E if it is 2am there would be 4 cells with
data in "B" and a corresponding subtotal in B49 and/but there would be a
subtotal in A49 subtotaling the entirety of "A". All 48 entries. I need a
subtotal of only the cells that match the cells in "BE" that are >0.
I hope I have made this example clear. Please feel free to request further
information should it be needed.
Clif Davis
Please feel free to contact me directly.