Question about Microsoft Excel for PC
I think I have a way for you to get this done. Open a.xls and then open b.xls. In b.xls, create a formula in any cell that you want to be updated based on the data in a.xls. For example, if you want cell A1 in b.xls to stay updated with the data from cell A1 in a.xls, your formula in A1 of b.xls would look as follows:
You can also create such formulas by following these steps:
1) Open a.xls and then open b.xls.
2) Place your cursor in the cell that you want to update dynamically in b.xls.
3) Enter the equals sign ("=").
4) Click on the "Window" menu in the top menu bar.
5) Select a.xls from the bottom of the menu items in the Window menu.
6) Click on the cell that contains the data that you want.
7) Hit Enter.
If you do all of these steps, you should find yourself back in b.xls with Excel having created the right formula for you. As a test, you can switch to a.xls and make a change in the source cell, and then you should be able to switch back to b.xls and see that same update.
Good Luck, hope this meets your need!
Posted on Aug 08, 2008
Tips for a great answer:
Oct 17, 2016 | Computers & Internet
May 24, 2015 | Microsoft Excel for PC
Feb 01, 2015 | The Computers & Internet
Dec 19, 2010 | Computers & Internet
Jul 10, 2009 | Microsoft Office 2003 Professional Full...
Jul 03, 2009 | Computers & Internet
Apr 24, 2009 | Microsoft Excel 2003 (065-03992) for PC
Feb 27, 2008 | Computers & Internet
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
113 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: