if todays date then stamp a set of values.

I have table of values which a total is calculated for each product type as it is updated at the end of each day.

Is there a way to setup another sheet to lookup the totals and then stamp them under the date, but not dissapear when the day ends.

In the end i'm looking for a daily record of the totals..

Hope you can help.

Thanks
Z

I don't have the knowledge of VBR to make this macro,
I can get it to copy and paste, but when it comes to making it match the column date to todays date and then copying and pasting the values into that specisfic row, that is a problem....

Any Ideas...

I got the formula : =IF(H$2=$A$1,$F5)

A1 : =TODAY()
H2 : COLUMN HEADING DATE
F5 : VALUE

Which is working fantastic and pulling the values under todays date.
The problem comes tomorrow, when the date has changed;
Todays values will go blank and tomorrows will be populated.

I need yesterdays values to remain...

Anyone??

Z

Hi,

Daily totals can be done more easily ... it depends on the number of conditions ...
Feel free to upload a zipped sample of your worksheet for a precise answer ...

Conditions, just need to be something along the lines of IF the line heading matches todays date, then the value of the cell = that days value.
The problem comes when its not todays date anymore as I want the values to stay, and provide a daily history.

Sorry can't uplooad the file..
Z

Hi,

Look into the Sumif() function ....and adjust today() to a cell ...

Please Login or Register  to view this content.

Ok then ...

Do you know the two step process :
1. Edit Copy
2. Edit PasteSpecial Values
...
Does it help ... ?

Yes ... to automate ...
Just turn on the macro recorder,
Go through your actions
See how VBA codes your steps in a macro ...