Help for newbie

T

Txl

Hello,

I have made a sheet to compute the meals from my newborn baby (yipee)

I have the following columns


A B C D
qty date time day total


I'd like to have the date and time fields automatically set when I enter a qty but if I use the now() function it recalculates the ENTIRE sheet everytime I add a new entry.

I have browsed the forums and I think one of the solutions would be to have VBA code telling the sheet that :

"When exiting the qty column, update the date and time on the same row only"

Or is there an alternative method that would force the now() function to perform its calculations ONLY on the "active" row ?

Thanks for the help
 
T

Txl

Thanks a lot, the formula indicated on the webpage you mentioned is just great...


Now on to the next question, I have a cumulated total for the day and I don't know how to set it

1 A B C D
2 qty date time cumulated
3
4 60 10/10 03.25 60
5 60 10/10 08.14 120
6 70 10/10 11.35 190
7 60 11/10 01.12 60
8 55 11/10 03.01 115


I'd like the sheet to behave like this, in column D i'd like to add all the values from column A that have the same date in B, and when B changes as in B7, then column D would start a new sum...

Thanks again for the help



First, you can put the date and time into one cell--and format it to show both.

Second, if you update the qty column, then the next column will be populated
with the date/time of your data entry--not time the baby ate.

Third, J.E. McGimpsey shows how at:
http://www.mcgimpsey.com/excel/timestamp.html
Click to expand...
 
D

Dave Peterson

If your data is nicely sorted (by date), you can use excel's built in
data|Subtotal to get that total--it won't be quite what you want, but it could
be sufficient.
Thanks a lot, the formula indicated on the webpage you mentioned is just great...

Now on to the next question, I have a cumulated total for the day and I don't know how to set it

1 A B C D
2 qty date time cumulated
3
4 60 10/10 03.25 60
5 60 10/10 08.14 120
6 70 10/10 11.35 190
7 60 11/10 01.12 60
8 55 11/10 03.01 115

I'd like the sheet to behave like this, in column D i'd like to add all the values from column A that have the same date in B, and when B changes as in B7, then column D would start a new sum...

Thanks again for the help
Click to expand...
 
Top