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
|
|||
|
|||
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 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 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 | |||
Formula copy | Excel Worksheet Functions | |||
Copy a Formula down with a Twist Q | Excel Worksheet Functions |