how can i copy formula?

[jp]

hi,
please help!
my problem was i create a formula that gets the total sum from another
workbook. i want to copy the formula and past to another cell but the only
thing must change is the name of the workbook.

example.
i want to paste the formula of A1 to B1 and so on which autoamtically link
to another workbook.

Workbook1.
sheet1
A1=sum of workbook2
B1=sum of workbook3
C1=sum of workbook4

[R.VENKATARAMAN]

in the formula bar highlight formula without = sign and control+C , hit ESC
key and go to some other cell even in somte other workbook provided both are
open and hit control+V . now add =sign in the beginning

try this . does it help?


jp <jaypee2cool@yahoo.com> wrote in message
news:ufAJ#C$DFHA.3928@TK2MSFTNGP15.phx.gbl...
> hi,
> please help!
> my problem was i create a formula that gets the total sum from another
> workbook. i want to copy the formula and past to another cell but the only
> thing must change is the name of the workbook.
>
> example.
> i want to paste the formula of A1 to B1 and so on which autoamtically link
> to another workbook.
>
> Workbook1.
> sheet1
> A1=sum of workbook2
> B1=sum of workbook3
> C1=sum of workbook4
>
>
>
>
>
>

[jp]

i want to copy the fomula in the other cell that gets the sum of the
workbook . when i copy, its automatically change the link to other workbook.
it thats possible?
"R.VENKATARAMAN" <$$$$vram26@vsnl$$$.net$$$> wrote in message
news:uAtbU6$DFHA.2572@tk2msftngp13.phx.gbl...
> in the formula bar highlight formula without = sign and control+C , hit
ESC
> key and go to some other cell even in somte other workbook provided both
are
> open and hit control+V . now add =sign in the beginning
>
> try this . does it help?
>
>
> jp <jaypee2cool@yahoo.com> wrote in message
> news:ufAJ#C$DFHA.3928@TK2MSFTNGP15.phx.gbl...
> > hi,
> > please help!
> > my problem was i create a formula that gets the total sum from another
> > workbook. i want to copy the formula and past to another cell but the
only
> > thing must change is the name of the workbook.
> >
> > example.
> > i want to paste the formula of A1 to B1 and so on which autoamtically
link
> > to another workbook.
> >
> > Workbook1.
> > sheet1
> > A1=sum of workbook2
> > B1=sum of workbook3
> > C1=sum of workbook4
> >
> >
> >
> >
> >
> >
>
>

[R.VENKATARAMAN]

sorry i have not understood. if itis <sum> formula why copy why not use icon
sum in the toolbar.

but if you want to link the first workbook sum in the second workbook

try this
in the first book edit copy the cell where sum is located
go the second workbook and to the cell where you want
edit-pastespecial-pastelink(in the bottom left hand side).
is this what you want?

jp <jaypee2cool@yahoo.com> wrote in message
news:O7dvKWAEFHA.3580@TK2MSFTNGP10.phx.gbl...
> i want to copy the fomula in the other cell that gets the sum of the
> workbook . when i copy, its automatically change the link to other
workbook.
> it thats possible?
> "R.VENKATARAMAN" <$$$$vram26@vsnl$$$.net$$$> wrote in message
> news:uAtbU6$DFHA.2572@tk2msftngp13.phx.gbl...
> > in the formula bar highlight formula without = sign and control+C , hit
> ESC
> > key and go to some other cell even in somte other workbook provided both
> are
> > open and hit control+V . now add =sign in the beginning
> >
> > try this . does it help?
> >
> >
> > jp <jaypee2cool@yahoo.com> wrote in message
> > news:ufAJ#C$DFHA.3928@TK2MSFTNGP15.phx.gbl...
> > > hi,
> > > please help!
> > > my problem was i create a formula that gets the total sum from another
> > > workbook. i want to copy the formula and past to another cell but the
> only
> > > thing must change is the name of the workbook.
> > >
> > > example.
> > > i want to paste the formula of A1 to B1 and so on which autoamtically
> link
> > > to another workbook.
> > >
> > > Workbook1.
> > > sheet1
> > > A1=sum of workbook2
> > > B1=sum of workbook3
> > > C1=sum of workbook4
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>