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


Hey all,

i have a weekly work sheet that i do were i have to sum employees time
(9.78) at certian places they work. all the times are in the "L" column
but there is diffrent amount of spaces between a group of times an
sometimes only 1 time for the job. i need a macro to search the colum
for numbers and auto sum them. so something like...

7.48
6.48
4.35
18.23 <--- sum

4.35
4.35 <---sum

and so on. thank you for any help in advance

--
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
Coloring Cell if Data is present oakman[_4_] Excel Programming 2 May 6th 04 08:39 PM
Change cell color if data present excel 2002 Mike[_80_] Excel Programming 2 April 29th 04 12:16 AM


All times are GMT +1. The time now is 11:56 PM.

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"