#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






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 can i copy formula? jp Excel Discussion (Misc queries) 1 February 11th 05 05:50 AM
How do you copy a cell formula down a column without displaying n. Coddie Excel Worksheet Functions 4 January 18th 05 02:31 PM
When I copy down into the next cell the formula changes correctly. Jason30 Excel Discussion (Misc queries) 1 January 12th 05 11:55 PM
Formula copy D Excel Worksheet Functions 1 November 24th 04 08:54 PM
Copy a Formula down with a Twist Q John Excel Worksheet Functions 7 November 23rd 04 10:03 PM


All times are GMT +1. The time now is 01:36 AM.

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"