View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
onesaint[_3_] onesaint[_3_] is offline
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