Hi,

I need some help. I'm not smart enough to figure this out, so I
thought some smart people may be able to help.

I need to automate a task. I need a macro that will fill in the
following totals.

example sheet:

A 5
B 6
C 7

TOTAL

D 5
E 6
F 7

TOTAL

G 5
H 6
I 7

TOTAL

The titles(letters) are in column "A" and values in column "B".
I need a macro that will give me sub totals in column B where the A
column states total.
How can I do this?

I have several thousand sub-totals I need and doing it manually would
take weeks.

thank you