Sheet1
column A:
Date
Mon/04/2006
Tue/05/2006
Wed/06/2006
Thu/07/2006
Fri/08/2006

column B:
total $ amount
$54,403.45
$73,648.33
$55,874.21
$60,030.05
$104,275.63

Sheet2
column A:
total dollar value of an order

column B:
the date of an order when it was processed


OKAY.... this is what i need, please.... sheet1 is already filled for the week. in sheet2 i would like to enter the date of an order when it was processed and the total amount dollar value of that order. i would like the total amount of the order to add to sheet1 (total $ amount) with the corresponding date.

hope i explained it right...