i want to past TOTAL of the selected cell data to another Excel file
Exp. I selec A1:Y1 have total 2000. so the total of the data, want to past
another open excel file

Qazi,

You could use a macro. With the cells selected, run this:

Sub PasteTotal()
Dim myTotal As Double

myTotal = Application.Sum(Selection)
Application.InputBox("Select the cell for the total", _
Type:=8).Value = myTotal
End Sub

HTH,
Bernie
MS Excel MVP


"Qazi Ahmad" wrote in message
...
i want to past TOTAL of the selected cell data to another Excel file
Exp. I selec A1:Y1 have total 2000. so the total of the data, want to past
another open excel file