Geek Answers Handbook

Link an entire sheet to another in Excel

I have two books that have sheets that should logically look the same. I don’t want to manually maintain their identity, so I want to dynamically link them (just as you would between cells using the formulas: "= A1"). I want to link the entire spreadsheet, not just a few cells.

Is there a way to do this without the formula 238427398729, thus crashing my car? Is there a way to say "= sheet2" as a formula defining the contents of a whole sheet?

+4
source share
2 answers

You may be able to use the Get External Data feature (depending on the location of the source file)

Steps to create in Excel 2010 (other versions of the menu are slightly different)

  • tab
  • Get external data / from other sources
  • From a Microsoft request
  • New data source
  • Enter your name
  • Microsoft Excel Driver
  • Connect and select source book
  • Select the required sheet
  • Ok to open request
  • Drag *to grid
  • File / Data Return to Excel
  • Select destination

The resulting related query can be manually and / or updated periodically.

+3
source

To dynamically link the entire sheet manually:

Create a new sheet, in this case Sheet5 will duplicate Sheet3

in cell A1 of the new link on the sheet, source sheet = Sheet3! A1

A1 (Sheet5 ) , . "I".

, , , , , 60.

( ), " " ( ).

0 , . , . , , .

, , . , . , . ​​

+2

More articles:


All Articles