Can I use a column to another spreadsheet in 1 Excel file?

Asked By monier 0 points N/A Posted on - 11/07/2011

Can I use a column as reference in one Excel file in another spreadsheet?  I want to be able to add a data in, let’s say A.xls and then the data in B.xls is updated too.

• Status: Open
• Question Views: 774
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by jaisonkallely

Go To Solution

Best Answer

Best Answer

Answered By jaisonkallely 0 points N/A #106602

Can I use a column to another spreadsheet in 1 Excel file?

 

Hi,

You can do this by adding a reference formula. Suppose you are entering the data in ‘A’ column in ‘A.xls’, the same column data can be updated in ‘B.xls’. For this you have to add a reference formula in the ‘B.xls’ file column where you want the data to be updated in this file. Eg: First enter the value in ‘A1’ cell of ‘A.xls’, and then go to ‘A1’ cell of ‘B.xls and type there ‘=’ and click the ‘A1’ cell of ‘A.xls’ and press enter. So the ‘A1’ cell of ‘B.xls’ will show the same value which is there in the ‘A1’ cell of ‘A.xls’. And the formula in ‘A1’ cell of ‘B.xls’ will look like “ ='[A.xls]Sheet1'!$A$1 ”. The formula can copy downwards to get the updates from ‘A’ column in ‘A.xls’.

I hope this clarifies your doubt. If you need more clarifications I can explain with Screen shots’

Regards,

Jaison

About jaisonkallely

Questions
0

Answers
2

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 11/07/2011
• Question Category: MS Excel

Answered By lee hung 75 points N/A #106603

Can I use a column to another spreadsheet in 1 Excel file?

Hello Monier,

Yes, you can do that, but then you will have to use the formulas so that when you update the details of one cell, those other cells that are part of the formula are updated to.

Choose summing up numbers for example. If you declare cell A to represent a number and cell B to represent a number too, and then another cell C to display the result, formula will be something like SUM(A1+B1)=C1. Therefore, anytime you change the value of cell A1 or cell B1 the result will automatically change. Other functions that can be used for the same purpose are the IF and multiplication functions.

__

Regards
Lee Hung

About lee hung

Questions
3

Answers
1451

Best Answers
463

• Vote Up 0 Vote Down

• Posted on - 11/07/2011
• Question Category: MS Excel

Answered By vikramchoudhary 0 points N/A #106604

Can I use a column to another spreadsheet in 1 Excel file?

Hi 

These is very easy. first you enetr data in first workbook than go to another and enter a formula that is =[Book1]Sheet1!A7

It will be done "Have a good Day"

Vikram

About vikramchoudhary

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 11/07/2011
• Question Category: MS Excel