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
>
>
>
>
>
>