| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
| 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 | |||
| When I copy down into the next cell the formula changes correctly. | Excel Discussion (Misc queries) | |||
| 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 | |||
Hybrid Mode
