Change sheet name to match the sheet you want the update done in.

In the Workbook module place the following code:

Private Sub Workbook_Open()

With Sheets("Sheet1")
.Range("J1").Value = .Range("P1").Value
.Range("A1").Value = 0
End With

End Sub

--
Kevin Backmann


"Mir Khan" wrote:

Hi Experts, i have a question with three column involved in it.
column A (where a number is entered [if required] whenever the file is opened)
column J ( where the previous total is stored)
column P (P1=J1+A1)
when ever this file is opened Column A should get set to '0' (zero)
automatically, and column J should get the value that is stored in column P.

i am not sure if this makes any sense to you guys. please ask for
clarification.

PLEASE HELP!!!