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.
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
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
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
