Re: Subtotal data of various lengths without entering Sum(...) man
- From: Jeff-B <JeffB@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 7 Aug 2008 07:47:01 -0700
Thanks for the reply, the data is laid out like this:
Day Sale Commision
01/01/08 1234 100
01/01/08 4321 100
.. . .
.. . .
5555 200 (Last row of the day
is the totals)
01/02/08 1234 100
01/02/08 ect
"Rick Rothstein (MVP - VB)" wrote:
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.
- References:
- Subtotal data of various lengths without entering Sum(...) manuall
- From: Jeff-B
- Re: Subtotal data of various lengths without entering Sum(...) manuall
- From: Rick Rothstein \(MVP - VB\)
- Subtotal data of various lengths without entering Sum(...) manuall
- Prev by Date: Close almost all workbooks
- Next by Date: MessageBox
- Previous by thread: Re: Subtotal data of various lengths without entering Sum(...) manuall
- Next by thread: Referencing Database Fields
- Index(es):
Relevant Pages
|
