Very many thanks. This is incredible! I have been doing
this task manually for some years. I must read more
manuals!

Peter
-----Original Message-----
There's an option built into excel that almost does what
you want. (but it puts
subtotals in the same column as the raw data).

Take a look at Data|subtotals

(Since this is such a useful function, I'd try to accept
the "wrong" column
stuff!)



Peter wrote:

I need a macro that will do the following for me:
I have an accounts programme that outputs to Excel.
Cells
C1:C70 contain the code "1300"; cells C74:c80 contain
the
code "1310" and so on for 820 rows. I need to insert a
row under row 70 and to put the total of J1:J70 in cell
N71. So the macro will travel down Column C and when
the
code changes, insert a row, and put the total in Column
N. Thus I will end up with the total of each code in
Column N. I'm sure it's not difficult, but I can't work
it out myself.
Thanks.
Peter

--

Dave Peterson

.