auto sum macro if data is present above the cell
 

Albert Delamo
Jobclock Name: Cora Date Range: 10/11/2004 Through 10/17/2004
Start End Activity
10/14/2004 7:22:22 AM 10/14/2004 4:34:34 PM 9.20 0.75 8.45
10/15/2004 7:10:32 AM 10/15/2004 2:57:46 PM 7.79 0.75 7.04 (total unde
this last figure)
Jobclock subtotal: 16.99 hours 15.49

Jobclock Name: pasta Date Range: 10/11/2004 through 10/17/2004
Start End Activity
10/11/2004 7:09:02 AM 10/11/2004 5:39:02 PM 10.50 0.75 9.75
10/12/2004 7:22:28 AM 10/12/2004 5:10:42 PM 9.80 0.75 9.05 (total unde
this last figure)

Jobclock subtotal: 30.35(incorrect)hours

Employee subtotal: 47.34(incorrect)hours $12.00 $411.48

this (if it comes out ok) is what the spreadsheet looks like. there i
usually 1-3 rows between each item. ill have to play with the subtotal
feature. vba is a little diffrent than vb and im a bit of a n00b when i
come to vb so... thank you for the help

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