2 wkbks- share and add info

[jbryant81]

I have WKBK #1...and I want to create WKBK (#2) which will always pull info from WKBK #1. In addition to that, I want to be able to edit WKBK #2 and add info w/o affecting WKBK #1.

Creating a 'backup file' and adding info to the 'backup' does not work...

HELP!! HELP!! HELP!! HELP!! HELP!! HELP!! HELP!!

THANKS!!

 

[bobby13]

that's really easy, you just need to link the workbooks. there are a number of ways to do that and they may take a while to explain all of them.

I'd suggest you check out these video tutorials; they will show you two ways to do what you are looking for and they're pretty quick and informative and will explain how to do what you want step by step.

http://www.teachexcel.com/tutorials/importexport/cell_linking_multiple_workbooks.php
http://www.teachexcel.com/tutorials/importexport/linkcellsworksheets.php
http://www.teachexcel.com/tutorials/importexport/importexport.php