View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
grimjim grimjim is offline
external usenet poster
 
Posts: 1
Default how to sum numeric values of column (variable length) in 1st available blank cell


Hi,

I have an invoice summariser xl document which takes the contents of
folder (ie. a quarter) and summaries the invoice contained in. As th
quarters can have variable numbers of invoices, I'd like to add
function which looks for the ist blank row in a given column (or an
column with numeric values if thats easier) and then totals it.
should imagine that this would be fairly easy, and a common requiremen
but I have been unable to find the appropriate code.

If anyone can help me out this would be much apprecciated.

Thanks in advance


And

--
grimji
-----------------------------------------------------------------------
grimjim's Profile: http://www.excelforum.com/member.php...fo&userid=1539
View this thread: http://www.excelforum.com/showthread.php?threadid=27009