how can i copy formula?

J

jp

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Auto-Adjustment 1
Macro copies values in other workbook 1
Export user inputs to a template and save it as a different file 1
Copied formula produces unexpected copied results 1
Copy data from workbook 2 to workbook 3 mystery! 2
Excel Formula 7
Need macros for copy data into new workbooks 2
Excel How to add numbers in same cell? 2

Top