how can i copy formula?
 

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

Hi Jp

Maybe you can use this example to do this
http://www.rondebruin.nl/summary2.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"jp" wrote in message ...
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

BTW : not possible with copy the formula cell

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ron de Bruin" wrote in message ...
Hi Jp

Maybe you can use this example to do this
http://www.rondebruin.nl/summary2.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"jp" wrote in message ...
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