Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jp
 
Posts: n/a
Default 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   Report Post  
Bill Manville
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE anantth Excel Discussion (Misc queries) 4 February 6th 05 01:25 PM
How do you copy a cell formula down a column without displaying n. Coddie Excel Worksheet Functions 4 January 18th 05 03:31 PM
When I copy down into the next cell the formula changes correctly. Jason30 Excel Discussion (Misc queries) 1 January 13th 05 12:55 AM
to copy a formula in cell c1 (+b1/b11) to cells c2-10, how can i . bvi Excel Worksheet Functions 3 December 23rd 04 07:14 PM
Copy a Formula down with a Twist Q John Excel Worksheet Functions 7 November 23rd 04 11:03 PM


All times are GMT +1. The time now is 03:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"