auto sum macro if data is present above the cell
 

also there is the word hours in the cell to the left of every cell tha
a sub total need to go into.

.75____9.35
.75____8.24
Hours__(Subtotal)

Kinda like that without the __

--
onesain
-----------------------------------------------------------------------
onesaint's Profile: http://www.excelforum.com/member.php...nfo&userid=937
View this thread: http://www.excelforum.com/showthread.php?threadid=27095

auto sum macro if data is present above the cell
 

A couple more questions: does the code need to insert a row for the total, or
is it already there? Can the subtotal be in a new column on the right?

On Thu, 21 Oct 2004 12:37:44 -0500, onesaint
wrote:


also there is the word hours in the cell to the left of every cell that
a sub total need to go into.

75____9.35
75____8.24
Hours__(Subtotal)

Kinda like that without the ___