Saving a column of values by date

[TypeR]

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..

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

[Carim]

Hi,

Why don't you upload a zipped copy of your worksheet ...?