Linking excel spreadsheets

  Robotic_Rob 00:51 27 Dec 2007
Locked

Hey,

My mother is trying to link 2 excel spreadsheets together in Microsoft office 2007 on a XP home machine. She wants one excel spreadsheet to calculate a few figures about 50 times and then she wants to copy the end value of each calculation into the second spreadsheet. Is they a way to do this? Or will she just have to type the end values into the second spreadsheet herself?

Shes collared my help but i haven't a clue :(


Cheers for any help.

  wiz-king 06:48 27 Dec 2007

If they are sheets in the same workbook then just copy & paste the cells with the answers into the other sheet. That worked in old versions of Excel, dont know about the 2007 version - havent tried it yet.

  estabond 08:31 27 Dec 2007

In earlier versions of Excel I have used 'edit / paste special / link
hope something similar is still available

Seasons greetings

  octal 08:31 27 Dec 2007

I think the basic formula is =Sheet2!B2 Just change the Sheet number to the one you want to copy from and the cell number in that sheet.

  Noodlestrudel 12:13 27 Dec 2007

Say the workbook with answers in is called "Calculate" and the sheet you want to copy from is called "Numbers"

Say the workbook you want to show the answers in is called "Answers"

If there's information in Cell D1 of Calculate and you want it in A1 of Answers, pop this into A1.....

=[Calculate.xls]Numbers!D1

The easiest way to do it is to put an = into the cell you are working to in the destination file, then navigate to where you want to take the info from in the file with the information, select the cell, and click enter. This will give

=[Calculate.xls]Numbers!$D$1

but if you remove the $ symbols, you can then drag the formula to surrounding cells!

  Robotic_Rob 15:36 27 Dec 2007

Cheers all that have helped me. I was looking for Noodlestrudel answer where it linked to completely separate spreadsheets. :D

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

50 best online Adobe XD tutorials

iPad Pro 10.5in (2017) review

Comment connecter un MacBook à une TV ?