|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 11th, 2005, 04:59 AM
|
|||
|
|||
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
February 11th, 2005, 07:28 AM
|
|||
|
|||
|
Make sure that any cell references in the formula are absolute (ie have
$ before each column letter and row number). Copy and paste the cell(s) normally. Then select all the cells you want to refer to a different workbook and Edit / Replace / current filename /(with) new file name / Replace All Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can I copy a formula where the referenced cells have an assoc. | cvgairport | General Discussion | 2 | November 5th, 2004 01:10 AM |
| I can't copy a formula, it returns the copied cells calculation. . | Tommie_45 | Worksheet Functions | 2 | October 4th, 2004 06:51 PM |
| copy cell contents but not formula | newbie | Worksheet Functions | 5 | May 14th, 2004 10:06 PM |
| Copy formula down | PCOR | Worksheet Functions | 6 | December 9th, 2003 12:29 AM |
| Problem with copy & paste formula | Mike M. | Worksheet Functions | 1 | November 17th, 2003 12:52 AM |
Linear Mode
