Hi there,

This works well....how can i copy this function down to specified cells in
Column Z?
--
Carlee


"Tom Ogilvy" wrote:

=sum(Master!D:D)

if you mean with a macro

tot = Application.Sum(Worksheets("Master").columns(4))

worksheets("Monthly").Cells(rows.count,"Z").End(xl up)(2) = Tot

--
Regards,
Tom Ogilvy

"Carlee" wrote:

Hello, me again,

Question: I would like to sum the values contained in Column D, on sheet
"Master", and place total in Column Z, on sheet "Monthly". Hitch: the
number in column D on sheet 'Master' is variable.

How can i accomplish this?
--
Carlee