Help for newbie

  • Thread starter Thread starter Txl
  • Start date Start date
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
 
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...
 
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...
 
Back
Top