| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i copy formula? | Excel Discussion (Misc queries) | |||
| HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE | Excel Discussion (Misc queries) | |||
| How do you copy a cell formula down a column without displaying n. | Excel Worksheet Functions | |||
| to copy a formula in cell c1 (+b1/b11) to cells c2-10, how can i . | Excel Worksheet Functions | |||
| Copy a Formula down with a Twist Q | Excel Worksheet Functions | |||
Linear Mode
