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

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by jaisonkallely
Best Answer
Best Answer
Answered By 0 points N/A #106602

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

qa-featured

 

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 75 points N/A #106603

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

qa-featured

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

Answered By 0 points N/A #106604

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

qa-featured

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

Related Questions