i have data in sheet1. iam working in sheet2. in sheet 1 i used sumif formula
to sum the amount given by the customer.but some time customer gives 2 time
payment. amount is sum in sheet1,but date changes

e.g
customer given 100/- on 12/5/06
same customer given again 200/- on 18/5/06

the amont is calcullated in sheet1. but how i can calc th date

Hi Hitesh,

did you think in a Pivot table?

it will be perfect to solve your problem

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"hitesh" escreveu:

i have data in sheet1. iam working in sheet2. in sheet 1 i used sumif formula
to sum the amount given by the customer.but some time customer gives 2 time
payment. amount is sum in sheet1,but date changes

e.g
customer given 100/- on 12/5/06
same customer given again 200/- on 18/5/06

the amont is calcullated in sheet1. but how i can calc th date

Perhaps this will help.........
It's a Change-Event macro to put the current date in the column B cell if
the corresponding column A cell is changed.........

Private Sub Worksheet_Change(ByVal Target As Range)
'Macro inserts date in Column B for change in Column A
ActiveCell.Select
If ActiveCell.Column = 1 Then 'Limits macro action to column A
If Not Selection Is Nothing Then
Application.Selection.Offset(0, 1).Value = Date
End If
Else
End If
End Sub

hth
Vaya con Dios,
Chuck, CABGx3


"hitesh" wrote:

i have data in sheet1. iam working in sheet2. in sheet 1 i used sumif formula
to sum the amount given by the customer.but some time customer gives 2 time
payment. amount is sum in sheet1,but date changes

e.g
customer given 100/- on 12/5/06
same customer given again 200/- on 18/5/06

the amont is calcullated in sheet1. but how i can calc th date