Link 2 files

  • Thread starter Thread starter Rich24
  • Start date Start date
R

Rich24

I have 2 files of excel, then I want to somekind of linking both of them, so
that I only need to enter the data in a specific column in one file then I
can directly get the same data in the other file. Is it possible for me to do
it?
 
--Suppose you have data in ColA:J in Book1 Sheet1.
--In Book2 Sheet1 cell A1 you enter a value/text which is there is ColA of
Book1 Sheet1.
--Use the below formula in Book2 Sheet1 cell B1 and copy across as required

=VLOOKUP($A1,[Book1]Sheet1!$A:$J,COLUMN(),0)
 
Open both files. Go to the cell where you want to start linking the two
files. Type the equals sign in the file you want to bring the data into and
'='. Go to the other file and click on the cell that you want to link to.
Then hit Enter. Then fill down or fill right, whichever you need.

To break this link, go to Edit > Links > Break Link.
 
Back
Top