Re: Subtotal data of various lengths without entering Sum(...) manuall

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I'd be surprised if there isn't a worksheet formula solution to your question. Can you describe to us how your data is laid out?

Rick


"Jeff-B" <Jeff-B@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:3CFAE038-54AB-45A4-9CB2-F836C3A64CF6@xxxxxxxxxxxxxxxx
I have a large sheet that is broken down by date of sale. I need to subtotal
each days sales. Is there a way to write a vba so that I don't have to
manually type sum(a*.A*) for each and everyday. There number of sales each
day is not constant therefor one cannot just use a constant range length.

.

Relevant Pages

  • Re: Subtotal data of various lengths without entering Sum(...) man
    ... the data is laid out like this: ... 01/02/08 ect ... There number of sales ... day is not constant therefor one cannot just use a constant range length. ...
    (microsoft.public.excel.programming)
  • More lay offs at Matthews
    ... Things still look bleak for Bernard Matthews, ... Europe's biggest turkey producer said last night that sales "have not yet ... A total of 277 staff have now been laid off from the Witchingham and Holton ...
    (uk.business.agriculture)
  • Re: Investment or bail out?
    ... driven primarily by sales of the 430 Scuderia and 599 GTB ... improved pricing and higher Q3 2008 revenues from the racing ... they've laid off 10% of their staff after selling 92 cars ... Aston have laid a third off, Bentley are closing for a chunk extra over ...
    (uk.rec.motorcycles)
  • [SLE] Do Sales 0wn the Techs?
    ... Ben Rosenberg wrote: ... > company they hired 500 sales people last September but at the same time ... > they laid off the people who deliver the services that these sales ... while the Techs get their rejects. ...
    (SuSE)
  • RE: Subtotal data of various lengths without entering Sum(...) manuall
    ... Is there a way to write a vba so that I don't have to ... manually type sumfor each and everyday. ... There number of sales each ... day is not constant therefor one cannot just use a constant range length. ...
    (microsoft.public.excel.programming)