LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Highlight a Cell if Data not Present AceWill Excel Discussion (Misc queries) 0 March 10th 10 04:18 PM
Auto Insert the present time when a cell is filled with a data, Dinanath New Users to Excel 2 March 8th 09 08:28 PM
Returning an empty cell when no data present Bryan Excel Discussion (Misc queries) 4 November 27th 06 10:51 PM
auto sum macro if data is present above the cell onesaint[_3_] Excel Programming 1 October 20th 04 08:35 PM
Coloring Cell if Data is present oakman[_4_] Excel Programming 2 May 6th 04 08:39 PM


All times are GMT +1. The time now is 03:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"